It is not as bad as it sounds. I've had two done twice so far. Next one is about 5 years. Preparation isn't great but I've gone through worse. One they put their stuff in the IV, I remember nothing until I wake up and it's all over. No pain at all. People make too big a deal of it I think. Funny story though.
By the way, Dave Barry wrote a good one on the procedure. Very similar to that one and it actually may be the same one, just don't remember it all.