North Carolina. And I wasn't actually aware that some doctors wouldn't do until after I had it done (reading about it online). I just called before my appointment to say I didn't need sedation. They said ok and wrote it down. They weren't really pushy during the appointment other than asking me why I didn't want sedation.
I thought it was going to be awkward but wasn't at all. We just chatted. It was him and an assistant. I was able to watch the TV of my colon while he was doing it.
For people who might be interested in following your advice, the conventional wisdom is that you should definitely look around when choosing the doctor. I.e. do not use a regular gastroenterologist who primarily does sedated colonoscopies, you want one who has experience with non-sedated ones. They have a better idea of what hurts and how to mitigate that.