Do whatever turns you on. A lot of texturing is done with plain old drywall mud. Much cheaper than texture paint. You can mix paint in if you want to thin it. Use as is and use different brushes, scrapers, etc, to texture. I once used a hand wisk broom and dipped it directly into the drywall mud and textured it right on the wall.