I went to Red at 28th one afternoon for a hookah. I've only been once, but I will be back. The hookah was probably the best I've had in Charlotte. I had the double apple flavor, which is my go-to, standard flavor. The woman running the counter said it was al fakhar shisha, which in my experience is one of the best brands. The hookah was just the right temperature and the hose pulled absolutely effortlessly.
I can't say what the night crowd is like, but during the day it was exactly what a good hookah hookah bar should be. Lots of old men playing chess, music playing in the background, relaxing furniture, and a lot of books around. The drinks were basically self service during the day and not too bad of a price; domestic beers were $3 and imports $4.50, but the hookah was only $13 which is pretty reasonable.