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.