Well... about to start prep for my colonoscopy tomorrow.
Kinda worried AF going into it.
If you never hear from me again, it's because I died while being roto-rooted.
At least my liver made a full recovery...
Gentlemen.
I find the prep to be worse than the actual procedure. Assuming a good anesthetist that is.
I second that. I did one recently enough and it was not a problem at all. Sedative plus the twilight anesthesia thing and you won't notice a thing.
My prep was 50 grams of Mannite dissolved in half a gallon of water to drink. Be aware that i suffer from Fructose Malabsorption, so it worked very well. But the nausea afterwards was horrible, lasting for about two hours, not to speak about the other side effects. That was all, i refused any sedative and laxatives, like every other real man
Antisthenes macho post in 3... 2... 1... 
By the way, @Antisthenes, real men are able to do things that normal men are afraid of. So feel free to go on with your teenage homophobic issues

EDIT: I forgot about the most modern method of colonoscopy, it's even better and non-invasive. You swallow a (quite big) "pill", which is a camera that records all of the way from your mouth to the exit. This way the small intestine and ileocecal valve is also covered. No pain, no tubes, no embarassment or shame involved.
It's over... We're going back to $12k.
always had the suspicion that you were proudhon
That actually gave me the biggest laugh of the day

Sounds like you should have had the sedative with the prep lol. I've heard of some people getting nausea and other issues, I avoided that luckily (I used picoprep, don't know if that helped). I did wish I had a bidet at home rather than just toilet paper. Super soft my ass.
I didn't think the pill was anywhere near as effective at detecting anything and is not reccommended for colorectal cancer screening.