I don't know if the OP has already had their colonoscopy yet or not, but to add to the conversation. I would reccomend you come right out and just tell them you do not want or would prefer to not have sedation for your colonoscopy procedure. Not sure if your GI Doc will give you a pre-procedure examination before your colonoscopy date, I guess I was lucky and was scheduled for a pre-procedure visit with the doc when I mentioned to them I was not really interested in sedation. He said fine that they do them with our without sedation at patient request. I mentioned that I would not mind a little Valium or something just to take the edge off and relax me, but he did say "no" to that,...that they are o.k. with no sedation or with sedation, but nothing inbetween it would have to be one way or the other for me.
So I went with no sedation, and I am very happy I did! The procedure over-all was very tollerable, and there were only 2 times where the doctor told me it would be somewhat uncomfortable when he was doing 2 particular specific turns, and it was, but it was nothing more uncomfortable than I have experienced when I've had bouts of periodic gastric distress, or when I've been getting vigorously fucked at times. As a matter of fact the Nurse Anesthetist kept saying she was surprised how comfortable I was with procedure with out sedation,.....if she only knew about how comfortable I am with my ass, rectum, and in having semi-frequent anal sex, and frequent anal masturbation practice with dildo's and wearing plugs. I found the entire procedure fascinating to watch and the doctor made sure they positioned the video monitor screen so I could see it. He did tell me though to not ask any questions or talk much till he was all the way in and then he would give me "a tour" as he worked the scope backwards and out of me. Origionally the Nurse Anesthetist wanted me to take my glasses off, but then I said how could I watch what was happening, and the doc told her it would be o.k. for me to leave them on.
So again, just ask. You probably will be given a choice. Again, at least for me it was not too uncomfortable as I mentally just remembered during the procedure how pleasant it is for me to take items up my butt.
Also, another quick piece of advice. Yes, it is very true indeed, the home "prep" they give you to take to clean yourself out, is by all definition, the...absolute...worse part of it all. The Qapik they gave me to drink tasted terrible, made me very nauseous, and gave me a headache. So I never finished it, I just could not do it, as it was making me gag drinking it. What I did, was take 3-large cleansing enema's, ones what reach into the upper parts of the colon and intestine, and they flushed me out enough to be cleaned out for my colonoscopy exam. I waited a bit and had my 1st colonoscopy at age 53 and I am on the 10=year plan (no pollups found and no family history), so now with 3 more years to go till the next one, and I am not going to even use the prep the next time. Just take a Microlax treatment to get things started and follow that with 2-3 large plain water or Dr. Bronner's castile soap enema's,..and I should be all set for the exam.