I think trying to keep a tally rather misses the larger point. You can’t properly determine the most impactful bad science of the last 30 years, because you’re not aware of all of it! These meta-studies are showing how often you find bad science when you dig deeper, but that’s just a rate of incidence, not an absolute number. There’s a whole iceberg of findings we haven’t begun to press on. Who knows what kind of stuff might turn out to be fraudulent? The real concern is about what kind of damage has been done to the foundations of knowledge, which compounds as we continue to do research on top of shoddy prior work.
Fraudulent research can be damaging along multiple axes, and I completely agree that there is probably a mountain of undiscovered fraud out there that continues to have negative downstream effects. I'm more skeptical of the idea that undiscovered fraud has a negative effect on the public perception of science. If even highly prominent known frauds have had little discussion outside of academia, why would undiscovered frauds affect the way nonscientists think about science?