The most pain I have had under medical auspices was for a few seconds while my broken elbow was being x-rayed, and then, a while later, at night -- but then I buzzed and the nurse gave me something to make it go away.
The most pain I have had in a dentist's chair was having to piss.