I'm looking for options to describe some course of action the overall result of which is very much at odds with, and even precisely the opposite from, what was intended. The word, "counterproductive" is somewhat synonymous with what I'm looking for, but it doesn't capture the sense of shooting oneself in the foot that I want. Here are some examples (but bear in mind that although they are all socio-political, and in areas of some controversy, that is because they best highlight the nuance I'm after; in the end, my question is only about English word usage, not politics!)
Netflix recently released a Dave Chapelle comedy special in which there were some jokes that some people believe were detrimental to the interests of so-called "trans" people. In response, some people have staged protests to increase support of those interests. However, suppose those protests were to backfire and the overall result be a diminishing of trans support. Were such a backfiring to occur, we might say that the Netflix protests were counterproductive, but that doesn't seem strong enough.
Suppose that the result of Edward Snowden leaking intelligence had actually been to make worse whatever it was he was trying to improve. Again, it may be true to say that his actions were counterproductive, but were the actual result to make things very much worse than they were before, I'd like something more emphatic.
I hope those give a sense of what I'm looking for. I want to convey a Homer Simpson-esque "D'oh!" when the unintended consequence becomes clear. "Counterproductive" lacks the sense of negative value judgment I'm looking for. I want something that connotes "you should have known better" in terms of culpability, and even the sense of "I wasn't expecting the Spanish Inquisition!" in terms of the tragic magnitude of the own-foot-shooting that has taken place.