I've seen it happen once, on an accidental OD on prescribed pain meds.... unfortunately, the patient happened to be a former linebacker and current LEO, so it was not fun during the first 30 seconds, but once he realized what happened, he was fine and grateful that we were there to keep him breathing and alive.
I have heard anecdotal stories about paramedics giving 2 mg of narcan and then leaving the room for BLS to carry the patient out, or giving 2 mg of Narcan as they are walking into the ER and letting the hospital staff deal with the projectile vomiting that follows. \
The majority of ODs who get Narcan don't wake up fighting, despite what many senior paramedics tell their newbies; I've dealt with more combative drunks than opiod ODs.
Probably similar to mine: good guys, good at the LEO stuff, not so great at the medical side, but if they can save a life with narcan before EMS gets there, they will. They are also the types who go into house fires with a fire extinguisher and try to put the fire out before the fire department gets there.
I do think the lack of oversight and accountability from a medical authority when it comes to LEO administered Narcan is one of the huge causes of this.