Usually IV sedation is given with a medication that causes amnesia, most people who said they felt asleep it’s simply the amnesia. With IV sedation, you can have conscious sedation and deep sedation. The lighter the sedation, the quicker you get back to feeling normal. For getting back to your apartment, don’t expect walking far. Your friend can drive or take a taxi or car share with you, but long distance walking or busing is not a good idea.
I had a tooth extraction followed by bone graft last week with IV conscious sedation. I don’t remember a bit of the treatment. Between waking up and me being fully aware, there are bits I remember and others I don’t. I remember they mentioned it was nice they can bring the portable payment machine instead of having me pay at the front, but I don’t remember holding the machine and paying. I remember leaving the office to get in the car and when we were getting out of the car, but nothing from the actual ride. Once at my place, I took a power nap and after waking up I would say that I was aware at that point. They recommend not sleeping too much to avoid interactions with your sleeping that night.