Yeah I did, a colonoscopy about 5 years ago. Doc said I was awake but I don't remember a thing about the procedure until when I was coming to, I remember looking at my nurse and thinking she was the most beautiful woman I've ever seen. I didn't want to leave the hospital but then my wife intervened and took me home
When I returned for my follow up the same nurse was there and ... well, she had a good personality. So I would compare those meds with being at the bar at 2AM.
Next time I had a colonoscopy it was virtual. No fun.