I have had 5 of them, first 3 were on the drug that jus makes you forget you had the procedure, love that stuff...wake up with a buzz and no hangover.
Last two were propofol, you actually recover faster on this stuff but no sweet buzz.
Suprep is the worst, the first two I used some other stuff which was gross but you only had to drink 16 ounces of it, turns out it was hard on kidneys so they switched.
My brother lives in Europe and he takes some sort of pill with a bunch of water which seems preferable by a lot.
My experiences have been a walk in the park, however, my Bro and Dad each almost got killed in their latest ones.
My dad is old and they pieced his intestine causing an infection which he ignored for a few days, doctor said discomfort was normal for a few days...but he pulled through.
My bro is 55 and while removing a polyp they nicked a blood vessel or something and it took them a while to stop it, a few years ago my bro had some weird condition that he produced too many red blood cells so he was put on meds to control it...that may have something to do with his bleeding issue.
Both have had several colonoscopies in the past with no issues. Dad says that was his last one, but he is 82.
My mom was killed by colon cancer, which was found when she was 59, so for me they are clearly worth it as an colonoscopy at 50 and 55 would have most likely saved her life.
Also make sure they are looking at the entire colon and not just the sigmoid colon.