I just wanted to share my colonoscopy experience, as the posts on this website really helped me when I was anxious about getting it done.
It's not that bad (or mine wasn't). The diet is a bit of a pain, the MoviePrep is a little unpleasant and the procedure is slightly uncomfortable. Yet, I was never in pain and it was all done and dusted in 40 minutes.
I had a light sedation, 2mg of Midazolam to be precise. It didn't affect me at all, in fact I'd probably do it without sedation next time.
Anyone who is feeling nervous about it, please don't be. It's a pretty straight forward and most people get through it easily.