I really loves hookah sessions. It's really relaxing. The flavor is good, and playing around with the smoke is awesome. And it's a nice way to chill with friends. Put some tunes on and enjoy. :D
I've smoked hookah with at least 30 of my friends, and none of them had any bad experiences. Noone felt sick. You do get lightheaded of you take 2 huge hits after each other, but that's normal.
As far as getting hooked, it takes way too long to set it up for it to become an everyday thing.