back alley said:
and...the quote of the week goes to...
...I'm the biggest baby when it comes to pain. I need a general anesthetic to have my hair cut!...
Glad you like that -- I know it's an exaggeration, but in reality, I've found that I'm far more sensitive to some kinds of pain than others are. Things like needle sticks, bee stings, paper cuts, things like that I find extremely uncomfortable.
The dentist I go to now is very good. He's up for retirement soon, so I am gonna have to seek another. Dentists around here advertise "we cater to cowards" and offer all kinds of pain control. They know that many people are total chickens when it comes to dentists and they do try to be sure of a comfortable session.
My worst experience was not with a dentist, but with an ER doc.

I won't go into gross detail, but it involves an accident with a sewing machine when I was in my early teens -- use your imagination -- and the "cure" was far more painful than the actual accident.

I know I shocked my parents and the ER staff with my vocabulary at the time -- I used words that I didn't even know I knew!
But seriously, one factoid that is not well known is that a lot of research into anesthesia, both local and general, back in the 1800s, was not done by medical doctors, but by dentists. They knew that they had the ability to save many teeth back then, but the treatment was excrutiating, and yes, they lost business because of the pain, and the fear of it.