How is not delivering care to people who need it the "intended" result, and whose intention are we talking about?
The whole purpose of health insurance is to deliver care where and when it is needed. If it weren't so there would be no purpose for health insurance at all.
"There is no financial sense (even across the whole society possibly) to keep people alive when that would cost more than you can ever get back from them."
And how would you or anyone else know what you're ever going to be able to "get back" from someone? You're saying that society is better off if we let all the sick and injured suffer and die. Unless of course they are rich enough to pay for their own care. So the rich, who can afford care, should get insurance because we know that some day they'll be able to 'pay back" the cost of their treatment, and the poor should have no care because we likewise know that they will never be able to pay back the cost of treating them. You've got a formula for a truly wonderful society there.
I hope that health insurance covers treatment for your sociopathy. We'd all benefit if you could be cured. Who knows, you might some day even contribute enough to society to repay the cost of all that treatment. I'd be willing to take a chance on you.