A colonoscopy is quite unpleasant; you starve for a day, and take an enema. They may sedate you before the procedure. If they don't, then the procedure is quite uncomfortable; not exactly painful, but unpleasant.
Incidentally, if they find and remove a polyp, they will plant a tattoo inside your gut to mark the spot, for the benefit of future spelunking visitors.