I've had multiple colonoscopies. The procedure itself is benign, it's the prep that's a bitch.
My first two were with the liquid, which was just brutal after the first couple glasses, but now I just take pills and it's much easier so long as your legs don't fall asleep on the toilet.