I've been referred for one. Wasn't too anxious, but the description of the MoviPrep experience has changed all that!
I have to have one every 5 years!! Always have the sedation, although it normally takes a double dose!
With a history of bowel cancer in the family, I have had quite a few of these procedures.
I reckon the worst bit is the starvation beforehand. Not too bad during the procedure, providing the 'plumber' is skilled; however, on one occasion, I had the misfortune to have a relatively inexperienced medic carry out the procedure under the supervision of the consultant. It was most uncomfortable and continued to be so for a couple of days afterwards.
... and is probably the reason I don't join in with Ring of Fire at the Amex to this day!
: