It varies by doctor. Usually, the more awful stuff they have to actually do, the less willing they are to issue pain pills for minor inconsequential things.
The guy who operated on my penis gave me a grab bag of pills that went right up to serious prescription pain killers and said just to call by if I needed more. I never even took the first day's pills, it barely hurt at all, but then he's a penis surgeon, it's not even essential to _have_ a penis, half the population don't have one so how important can that surgery be?
The guy who used to be my dentist before he retired was a Max Fac surgeon in his day job, dentist was how he relaxed before the weekend. So, normally he's putting back together ruined faces from car accidents and that sort of thing. Need a filling? "I can numb that, but it's in your lower jaw, and it's not touching the root, so I suggest we go without, then you won't drool for the rest of the day". "OK, but it will hurt?" "Barely at all, slight discomfort, weird sensation, no real pain". He was right, it was fine, definitely worth the small amount of discomfort to be in and out quickly and not drooling like an idiot.
On the other hand, when I was a kid I got hit by a car (my fault), they used Entonox (medical laughing gas) back then, I was high as a kite, and given the car smashed me good, that was probably the right call. So I'm not saying "I never use pain killers" but more like "I think pain killers are something to reserve for when it's really bad, not the first thing to reach for every time".