My dentist didn't give me Vicodin[0] unless I had more than one or two teeth out. Even then I never understood how people could like it. I got a little pain relief and a little bit of a relaxing feeling. It was probably a really low dose as well.

Might have just been mine wasn't into giving out prescriptions or they didn't think I would need them.

I have a friend who has so many pain prescriptions after his back surgery that I've lost count of and they either don't work or lose effectiveness or he can't deal with the side effects. The scary part to me is there will never be an end for him unless there is some miracle in medicine that his doctor doesn't know about yet.

[0]I know that's not the same as Codeine