My first colonoscopy was without anesthesia, and it was as described above. A little uncomfortable on the one bend, but I don't even think I would put it at 7/10 (perhaps a 4 or 5—but not a sharp pain, mind you).

Definitely enjoyed the following times with anesthesia because, of course 0/10 as far as I know. Also, anesthesia just trips my mind—how seemingly time travel (going forward in time) seems to be involved.