I had sedation for the removal of 2 wisdom teeth and I can honestly say it was brilliant, I wouldnt hesitate to have this again if I needed to,
Firstly you are given an injection to relax you, they ask you to count to ten as with a general but you dont go to sleep, you just feel very very relaxed you can hear whats going on around you but your off in lala land! :) you wont feel the injection or any pain, you may feel some tugging but it doesnt hurt and the dentist normally talks to you throughout the proceedure, I was as petrified as you are but it really is ok, after they've done it you might have a little sleep and then they send you home, you have to have someone to drive you home and after you've had the treatment just go home and sleep because you cant remember anything for a few hours after, so dont go writing any cheques or making rash purchases! :)
I have given birth twice and out of the two experiences give me dental sedation anytime!! Good luck xx