I have a Hookah, but I haven't used in a while.
It's no fun smoking by yourself; smoking the hookah is definitely a social thing. I just wish it was a little stronger (probably haven't tried the right tobacco).
If you're looking to buy one, don't buy one at a brick-and-mortar store. Way overpriced.
Go online and research some of the vendors.
www.socialsmoke.com is where I bought mine. No regrets and they have great specials.
Peace.