I had coloscopy once, without any meds or narcotics. I certainly didn't enjoy it, but it also wasn't a very bad experience at all. A couple of kinda numb feeling pinch-like shoots of light to medium pain sensations, nothing that gets you worried. The "hose" is 10mm thin, so even thinner than an index finger.
Get over your fears and get it done. Don't worry you might enjoy it, because you won't.
Taking pills before coloscopy is something for the ladies
(sorry ladies, no offense)
EDIT: Just saw the dump. Unexpected, but not that of a surprise, too. #hodl on!
Civilized colonoscopies are done with intravenous diazepam, inducing a dreamlike half sleep which allows you to watch the procedure on the monitor without any discomfort. You don't even feel the insertion.
The worst part is the day before, evacuating your colon with a gallon of disgusting fruit-flavored laxative/electrolyte solution and shitting increasingly lighter-colored liquids until it's clear.
Not to mention the farting that follows...
Haven't had a colonoscopy myself, but have witnessed the aftermath. I remember waiting in a queue at a hospital, to see a gastroenterologist. There were two guys there, one had finished a colonoscopy and was recovering, and another one waiting to have one. The first guy said to us that he was soon going to start farting (the nurse had told him he had to let it all out) and apologized for this. Man, this was something. He started a non-stop farting concert, so long and loud, it was like he was first violin in the Vienna Philharmonic. All of us in the room were crying from laughter. Then the doctor came and said they had run out of normal "tubing" and had to use the "anaconda" (whatever that means). The guy that was waiting for the colonoscopy got scared and left shouting "I ain't doing this shit!"
Damn, that was an experience I'll never forget.
