Honestly I think Hitchen's was a bit overdramatic with the whole experience, he knew what was coming, and anticipated it at first. But then again try pouring water up your nose, you'll stop rather rapidly.
As I said before, I do know of a few people who have been waterboarded in a BDSM context, for whatever it's worth, if you enjoy puking and gagging, then it's for you.