You can give someone a small dose of Midazolam, they might report feeling a little dizzy, or say they feel like they’ve had a few drinks, but they will have absolutely no recall of the experience, despite interacting like a slightly tipsy “conscious person” - I like how they call it “conscious sedation” - most people end up believing they were unconscious.
I've read some horror stories online about people having postoperative nightmares about what they experienced while on the operating table while under versed, so I was really afraid to take it when I went under general anesthesia myself.. but I've had it a bunch of times now, and never experienced anything like that myself.
My postoperative amnesia has been complete, and I'm happy for that.
On the other hand, I still worry about what I might have experienced that I don't remember.
There's also an interesting thing where the anesthesia you get is likely to be very different for the same procedure if you get the procedure at a hospital versus an outpatient clinic. Because anesthesia at a hospital is typically a department with influence, and turf wars happen.