Very true. I broke my wrist last night and they tried to give me vicodin. Albeit my wrist was in quite a bit of pain but it wasn't worth going into some pain-killer stupor for a day over. I asked for something less intense and got a prescription of some extra strength ibuprofen to help reduce the swelling and inflammation. I've been perfectly happy with it thus far, and probably won't take it any more than I have to. In my opinion pills can only do so much, a proper diet, rest, and exercise is what is really needed to be happy and healthy.
I did the same with a sprained shoulder a year or so ago. The doctor prescribed Vicodin but said I'd do just as well taking Advil by the handful. I killed a bottle in about a week and the narcotics weren't necessary.