Linds - the local was for the hand surgery. For endoscopy or colonoscopy I could accept something for pain, but no Versed. Opioids, fentanyl make me vomit, and the propofol available is usually the cheap generic with sulfite. So there's usually nothing they have to offer me.
Frankly it's not worth the side effects (for me) to have anything but the throat spray for endoscopy and nothing for the other end. It's all over in 10 minutes. Yeah, that 10 minutes hurts a lot. But I like not being asleep and not needing recovery, and being able to drive myself.
I've got another colonoscopy coming up. Now I have to check out the new less fluid prep. It's got soda bicarb, so I need to know how much, since I can't burp after fundoplication. (bicarb plus stomach acid = gas)