It's quite common here in Germany. I know several doctors who routinely do it without anesthesia, to avoid the dangers of sedation. Having seen a colonoscopy done that way a few times, I'd personally insist on sedation. Most people I've personally observed who were awake for the procedure seemed to find it almost unbearably painful, although there was a minority who didn't mind it much.