Illegal diversion in the supply chain does not tell us anything about whether the healthcare system is over-prescribing pain medication.

Let's just take your example. What do you believe is more plausible? That a town of 400 people are collectively prescribed 10,000 pills a day by well-meaning doctors? Or that the pharmacy from your example is a front for organized crime to funnel prescription opiates into the black market?