That's not my experience. Dental local anaesthesia has improved hugely since I ws a kid; the only really unpleasant dental procedure I've had recently was a root-canal. Routine filling replacements were uncomfortable, but painless, and much quicker than a colonoscopy.