I have had a colonoscopy and it is quiet, just some doctor searching your intestines with a camera. The only major discomfort is the pressure sometimes inside the intestines from the eqipment , like moderately hurtful cramps.
BTW : CT scans are quiet also, unlike MRIs ,which are to be avoided at all costs if you have h.!
Marco