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...