I had an endoscopy more or less followed straightaway by a colonoscopy just 4 days ago. I was a little nervous about it, so I opted to have the intravenous 'relaxing' sedative (ie....I wasn't out cold at any point) administered beforehand. I also had the anaesthetic throat spray in order to suppress the gagging reflex.
Taking the laxative prep (Moviprep) beforehand was just an absolute necessity. It didn't taste too ghastly (speaking as someone who endured treacle & brimstone / cod liver oil / syrup of figs + another awful preparation - the name of which I forget, as a child). It did indeed result in quite a few visits to the toilet!!.
I was calmer than I expected (partly due to the sedative I know). It helped that I had been talking to a friend beforehand ( who had been through both procedures). "Just remember," he said, "it doesn't affect your breathing at all." Very sound advice. I did not gag. Part 1 was over in 5 minutes.
The colonoscopy wasn't too bad. I did experience some discomfort (even with sedation) when the device encountered some of the inevitable bends in the alimentary canal. I was allowed to self - administer entanox, but not really shown how to use it properly....but I survived. (Kinky? I quite enjoyed the sensation of the scope entering and exiting my anus. I wasn't aware of being lubed up beforehand). I had been given a gown with the lower ties missing. The nurses who admitted me for the pre - procedure checks and prep were most apologetic about it and slightly flustered (worried about my modesty). I told them it wasn't a problem. There were probably several people who could see my backside during the colonoscopy (c.15 - 20 mins). To be honest, I did not care at all.
Post recovery (just for the sedation to wear off) was fine. I was hooked up to a small machine (for 30 mins) which measured pulse rate / oxygen saturation / blood pressure. I felt fine and I was allowed to have tea and toast (very welcome after not being allowed to eat for 30 hours beforehand!!). After 30 mins my cannula was removed and I was allowed to get dressed and then my wife drove me home. No after effects of any kind.
My advice? Get it done. Mine was set up by my Doctor following a routine blood test, which revealed that I was dangerously anaemic. This is the scary part. It turns out I may have colon cancer (despite my screening test coming back clear only 5 months ago). Even scarier, I had no symptoms. Who knows...This colonoscopy may have saved my life. So, if you are due to have one. Go right ahead. Don't put it off. The procedure itself is OK. If I can take it, anyone can. Whatever you do, don't die of embarrassment.