This page has some pretty good information on it:
https://www.gastrooffice.com/blog/am-i-put-out-for-a-colonoscopy-or-upper-endoscopy
I was awake for an upper endoscopy and colonoscopy. My doctor repeatedly told me that I wasn't awake and I won't remember anything and I told him that I am absolutely awake and me choking on the endoscope and in pain from the colonoscopy is not from me being asleep or in twilight.
After a few back-and-forths, I finally yelled "look mother******, I'm awake"
When I went in for my follow-up a couple weeks later, I sat down next to him and said "I guess I owe you an apology for what I called you." He looked up at me with this amazed look and said "you remember that?". I said, I told you several times that I was awake, of course I remember."
He told me that they had given me triple the dose of the twilight drugs, but I guess that I was too amped for them to work. We agreed we wouldn't go that route next time. :hihi:
That was over 22 years ago and I still remember. I go to a different doc now, but I've been put under for all procedures since that one.