Here's one showing only 5% of people filling opioid scripts go on to long term use.[1]
Another older study citing 2% of US adults regularly using opioids, while a further 29% use them infrequently. Other more recent studies I seen hold this pretty constant. [2]
Here [3] only 13% of elective surgery patients fill opioid scripts beyond 90 days, and "mental health disorders, and tobacco dependence or abuse were associated with prolonged opioid use". It's well known that people with one substance abuse issue tend to be at higher risk for developing others.
You could go on and on finding studies that show that relatively few people with high risk medical/mental health history go on to develop opioid addiction after using these substances. There doesn't seem to be any support for the idea that the average person can take these drugs once and become "hooked".
All that said, they are dangerous and have strong addictive potential so caution is warranted.
[1] https://link.springer.com/article/10.1007/s11606-016-3810-3?...
[2]https://www.sciencedirect.com/science/article/abs/pii/S03043...
[3] https://www.sciencedirect.com/science/article/abs/pii/S03635...
And for what?