As far as Greenville goes, this is my first pick, though I don't really frequent many of the clubs here; over the 10+ years here I've had a good and meh experience at all of them.
The ladies here are at least the same level of attractiveness as the other clubs in town.
Set your expectations in the right place, then have some fun - Review of Trophy Club • 450 Airport Rd
Greenville, SC 29607 - tuscl