I had my colonoscopy, without sedation, ten days ago. I barely noticed the scope until the two bends in the colon. Then I experienced about 3 - 5 seconds of pain as the consultant manouvred the scope around each of the two bends. It was similar to a bad period pain but as it did't last long it was soon forgotten. I would happily repeat the excersise, if required. As I was awake during the procedure, I was able to follow the journey on the screen and found it very interesting. Luckily, nothing of concern was found.
What I would not repeat is the drinking of 2 litres of Moviprep. I prepared the first litre at 5pm and at first it was acceptable but by the time I got halfway down the last glass I really did not want to finish it. I did eventually finish after downing a couple of glasses of water. A couple of hours passed and I made up the second litre of Moviprep. I swallowed the first glass but was retching and when I started to drink the second glass I threw up and had to take a break before I finally finished the remainder. All sips followed by lots of water.
After the event I found out I could have asked for a preparation called Picolax and would only have had to drink 2 glasses of the mixture instead of 2 litres. This would have made a big difference to my experience. I wish I knew of the option beforehand and that is why I am naming the preparations so others are aware of the choice. Other preparations may be available.