When something has negative externalities, the answer isn't to ban it, it's to tax it in proportion to the pro rata share of the negative externalities (and then maybe waive the tax if you have a prescription; but maybe not -- they seem to be overprescribed as it is, and the negative externalities don't disappear when you have a prescription).
If you want to pay $2000 for useless antibiotics, no problem. But the price will deter enough people that we don't get the scale required for widespread negative consequences, especially when insurance companies won't cover it without a prescription. Then the money can go to subsidize medicine in general so there is no net consequence for overall medical costs or insurance premiums.
And we could do the same thing for heroin with the money going to drug treatment etc. and do without all this business of SWAT teams and drug cartels.