Requesting to add
#coloscophobia

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)