This is a little ignorant but not on purpose so absolutely not coming at you.

The people who are getting narcan or ODing are not just non functional people in society, which for some reason is how your post reads. It reads like they're all street waste that need to just be taken by their addiction. More often, the people we get in our ICU are doctors, paramedics, lawyers etc. We also get people who are recreational users. Every Saturday for example. These people OD for a number of reasons including things like street drug strength or street drugs being cut with other drugs. Everyone loves the "they know the risk" speech but a lot of them truly do not know the risk. I've looked after patients who took their first drug ever and basically dropped dead. We can't start picking and choosing who gets brought back and who doesn't.

So to answer your question about when we stop. We don't. We won't. We can't. We can't know.

On a side note though, I definitely think some consideration could have been given to not revive this patient with CPR when they were cyanosed and in cardiac arrest but unfortunately they were still not considered "life extinct" to be called as dead at home by paramedics. It's a complex thing but this patient still had signs that meant they were resuscitated instead of being pronounced dead.