Also, I'm very envious of posters on threads like this that say they didn't remember a thing after sedation. I've been sedated many times, and most definitely remember everything, every time, there's different levels of sedation apparently, from just a light calming down dose, to completely out of it. I've no idea how they decide what level to give you, seems a bit of a lottery!
There are different drugs used for different reasons.
For anything unpleasant midazolam is a favorite because it does cause short term memory loss. It is of particular value if someone might need a repeat procedure.
The ideal from the medic's point of view is awake enough to follow orders but sedated enough to not care what they are doing.
I had a colonoscopy and was asleep until my arthritic knee decided to wake me up with pain. The staff were terrified I would move at that point and I remember saying I needed to stretch my leg and could they hurry up. Once I'd stretched I don't remember a thing until I was in recovery and farting.
I do remember recovery, lots of people on trollies with curtains around and all you could hear was farting and the sound of a lovely Jamaican nurse calling us al 'darling'.
If you are awake and feeling things ask for more sedation.
A friend had sedation at the dentist, I was with him for recovery and he thought is would be hilarious if I helped him off the bed. On the way home I had to stop for bread, he would not stay in the car and decided the Co-op was the ideal place to practice ballet (he studied dance for a year) and everything was funny.