For myself and many others, it's not really about the pain (supposedly there is little to none), it's just the unsettling thought of that scope so far up one's...
I was sedated with Propofol and that seemed to be routine in the facility I went to. It was a white fluid that came in through an IV. I remember saying to the nurse as I saw the propfol going in "that tingles..." and she said "that's normal", but it seemed to me that she said her answer before I finished saying "tingles", then a herringbone pattern visual from my tightly shut eyes, then nothing, and I woke as I was being wheeled out to the recovery area and felt no grogginess at all, seemed that only a couple seconds had elapsed from the time I saw the propfol (it was 20 minutes). Powerful drug.