It's too late to comfort Gr33dy with this, and he already knows that the prep is miserable, but I had one in my twenties, and the actual procedure was terribly pleasant. I had twilight, felt no pain, remember almost nothing, and am told I yapped nonstop through the entire thing. The PA assisting was a friend of mine, and reported that I told rambling stories from my childhood start to finish, and that when the doc gently interrupted one about a creek we used to play at at near my friend's grandmother's house so he could warn me there'd be a small pinch, I snapped "For Pete's sake Christian, you're a good looking man but a terrible conversationalist, stop scaring me ever five minutes and let me finish this story!" (Apparently he replied "Very sorry, please continue.")
I remember nothing but a dim room and a comfortable bed.