Would it change your viewpoint at all to know that a lot of chronic pain patients are now committing suicide rather than face a life where they are bed-ridden and dependent on a loved one for care? And all they need is a medication and they could have some quality of life? What about the people who have been responsible with their prescriptions but are now forced to buy potentially deadly black-market opioids like heroin and fentanyl from a dealer that is surely less concerned about their health and safety than their doctor, if they want relief?
That is extremely non-compassionate. I would never wish that on you or anyone else.
I don't think that is what you are trying to say, but I struggle to see how your logic doesn't ultimately reduce to that.
Edit (after thinking more): your example of the codeine is definitely a good example of over-subscribing, but my dad had a vasectomy that ended up being a horrible recovery. Luckily he was able to sit on the couch with a bag of ice under his balls and watch football for a week, but the man was in some serious discomfort.
I tend to think education is the answer. Teach people about the risks, and then give them freedom to decide. If we boil society and our laws down to never requiring or allowing people to take responsibility for their own actions and decisions, then we end up in a bad place IMHO.