Perhaps I can start.
We have a most excellent Canadian Guideline for Safe and Effective Use of Opioids for Chronic Non-Cancer Pain. That is a definitive authoritative source for striking that balance.
I think it's good medicine to take a good history and to monitor your treatments after you've prescribed them.
Regarding your first question about other prescription drugs that are not opioids, this is where we need good epidemiological data.