Houston was always great for me when I visited, before I settled here. After moving here, business is still very steady and plentiful. Represent yourself well, and Houston responds. Austin was always hit or miss for me, as was San Antonio. Dallas and Houston are much more reliable, but that is only my personal experience.
As for Houston being "hostile" maybe it is. There are definitely some trolls here who get off on getting a rise out of thin-skinned ladies and gents. If you aren't too easily riled and are capable of ignoring the riff raff, you'll find Houston very pleasant. I do.
And obviously we are not all trashy, ghetto, tatted-up thugs. The guys you've seen complaining about that are probably shopping in the Walmart section of hooker world and complaining about getting Walmart quality at Walmart prices. There are plenty of classy, reputable ladies here. We just generally charge more than Walmart shoppers are willing to pay. Hope you enjoy your visit!