I've known quite a few heroin addicts who got started because of a prescription for relatively mild but on-going pain. At some point the pain was gone, but the desire/addiction was not... Perhaps I'm just weighing my anecdotal knowledge too highly.
I'm not saying opioids are always inappropriate but I think a lot of situations could do without them if marijuana was available as an alternative.