It's actually very hard to get away with genuine scientific fraud because if the results are important the next person relying on the results will discover they are questionable. Inconclusive experiments are the normal result from even the best of experimentalists. The usual kind of fraud or waste is just research that was not important to begin with or never resulted in anything.
So, do we have documents of the findings and conclusions of the investigation itself, or just allegations of fraud? Allegations of scientific misconduct are freely thrown around by jealous competitors and at least 90% of such allegations are just that. There are cases where there was real fraud, and a lot of cases where the investigation concluded that there was nothing.
And yes, I am excusing nothing in global climate change but most of that started with politicians deciding what results they wanted and then funding 3rd raters to do work that no competent scientist would do.
A huge percentage of published scientific research can’t be dupplicated, of course the social sciences are the worst offender. For the social sciences I think I have seen figures as high as 75% unrepeatable. Biological sciences have had some huge scandals. A fair amount of fraud exists but I think the majority of it is due to sloppiness driven by academic “publish or perish”.