It is extremely common in the US. The only people who get colonoscopies without any sedation are those who want to be able to drive themselves home afterward.

We have people - covered in tattoos - who insist that they are terrified of needles. And that they want drugs before any even mildly painful procedure, like placing an IV.