I'm waiting to learn when I go for my 2nd colonoscopy - supposed to be this year sometime.
The first was three years ago and I woke up during the process. Heard some talking, looked around at what was on the monitors, said "thanks for the tour" and went back to sleep.
The proceedure was a non-event except they would not let me leave afterward until someone physically showed up to drive me home. The beforehand prep was not so enjoyable. Had to stay within dashing distance of a toilet for a day ot two.