I've had IV sedation twice for dental work.
I can't begin to put in to words my level of phobia when it comes to the dentist and, in fact, more so needles. Unfortunately, a needle was necessary and with the help of Emla numbing cream and someone talking to me to distract me, I was able to have the IV sedation.
It is wonderful.
I was extremely worried that it wouldn't work, I'd know what was going on, I'd feel everything, I'd remember everything etc... That couldn't be further from the truth! I remember being completely with it (although absolutely hysterical while actually getting the IV placed) then... nothing! I feel like during the second time I vaguely recall stirring slightly but it's just a very very distant, foggy memory and there is no trauma or anything attached to it - they obviously just pushed a little more sedation and I slipped back under.
I genuinely remember nothing. I felt nothing. I vaguely remember leaving the dentist but, again, it's very hazy. I went home, slept for a few hours and was no worse for wear when I woke up.
I would highly recommend it and wouldn't hesitate to get it again.
Wishing you the best of luck and calm vibes.