No mention of the word pain or hurt or did I skip over it? sounds like you were more nervous and worried about sounds and what not!
Personally, I also dread and fear the dentist more than anything, I don't care about needles, surgery, anything like that, even had a wound cautorized without anaesthetic.
But... when it comes to my gob and dental work, nothing has ever stopped it hurting as if I had zero anaesthetic, it's numb sure... but it still HURTS beyond the ability to control myself, I can only assume it would be like being tortured via the direct stimulation of nerve endings.
Second to that, the only place I have an aversion to needles is my gums, I once had a needle snap and get trapped in my gum, it was like someone hit me in the face with a truck I just lurched in pain, then came the pain of having a needle, stuck in your gums, being cut out with a scalpel and it hurting more than anything I have ever experienced in my life to date, ever, EVER.
Last time I went to the dentist, I went under general anaesthetic, mainly because everything that needed done was well over an hour and I just can't deal with that
This is all coming from me who says getting a tattoo often "tickles".