I've had procedures at the hospital two ways...
One is general anaesthesia, where you are "out"
The other is with something like fentanyl where you could have a whole conversation during the procedure, but when you finish the procedure, you don't remember it.
The experience afterwards is pretty much identical, but philosophically both seem very different.