Fair. But this is an example of something egregious by all standards. Sure, we can also remember Jacques Benveniste. Or recent ivermectin fiasco. And are we considering that superconductor story from last year fraud or just negligence?

Maybe a handful others can be found active today, but the number of those that attempted such a risk would be very small — probably several hundred bold enough to disrupt their area, virtually unnoticeable from outside perspective, and a couple dozens willing to try to act at a scale visible by popular media (well, like example you provided).

That’s what I mean by rare. I would call these outliers in terms of scale/frequency because incidents like these were allowed to happen and did not pop out of thin air. They are not a root of the problem, but rather a byproduct of how academic publishing, financing, and recognition work as a system. The random article you would try to replicate would with a certain far-from-zero probability fail not because the authors had a grandiose idea of how to fool the academic community and gain fame, but likely tried to fit in their poor results in the publishing process that requires novelty and constant publishing regardless of the quality of research, or else they lose their position/group/lab/not gain tenure/not gain next grant/not close the report etc. And that is more problematic and brings far more distrust in science, even among academics themselves, than any vaccine- or water memory-related nonsense.