Wow... sounds like a lot of you had bad experiences with the colonoscopies. Mine went without incident. The only needle they used was for the IV insertion. Slight pain but then again I'm not bothered by needles. It would be bad for me if I were bothered by them as it seems every time I visit the doc she orders a blood test (maybe 10 in the last 3 years).
As with everybody, the prep was by far the worst part. I did not throw up but was definitely on the verge of it as I was getting close to finishing the gallon of lemony nastiness. It's interesting to note that I haven't had any lemon-flavored drinks since then (3 months ago), all subconsciously.
I had both the endoscopy and colonoscopy done at the same time. Whatever they used knocked me out almost instantly. I remember waking up during the colonoscopy portion but the nurse anesthetist took care of that within seconds from what I remember.
I'm dreading the fact that I'll have to endure the nasty prep stuff again for my upcoming pill cam