Personally, I find a great deal written about so called "renewable energy" is fraudulent, including the general term used for it, but that's just my opinion, so for whatever reason it came across my desk, I posted it, just for fun. I very much doubt "renewable energy" is sustainable. There's no evidence that it has any capability of addressing climate change.
Thus I was amused.
"Retraction Watch" is an interesting read, and it covers papers published a very long time ago.
I've only had to fire one person for submitting fraudulent data, and that too was a very long time ago. It was my own fault, in the sense that I didn't supervise - better scrutinize - the guy. It was, however, the only time that I fired someone and didn't feel bad about it in any way.
Obviously though, problems occur frequently enough to justify the existence of "Retraction watch."
Sometimes the existence of fraud, real fraud, may lead to over public reactions though and assume that all work connected to a hypothesis is fraudulent.
I wrote about a case along these lines in this space some time ago: Some remarks on purported fraud concerned with αβ oligomer hypothesis in Alzheimer's research.
The other day I was reading through this popular science book about a subject about which I know very little, psychology: How minds change, where it referenced this case: Author retracts study of changing minds on same-sex marriage after colleague admits data were faked
As I read - more "skimmed" than read - the popular science book, the author was claiming that even though the data in this case was faked by a guy named LaCour, who had an offer to join Princeton's faculty rescinded, the type of approach to getting people to change their minds, "deep canvassing" might actually work.
I suppose, but do not know, that wherever a subject is arcane enough, and/or poorly supervised, an opportunity for fraud exists.
Another mechanism is of course, is popular madness, aka "mass hysteria;" fraudulent ideas go mainstream by the ad populum fallacy whereby criticism of the fraud can lead to serious social consequences: In the case of the claim that so called "renewable energy" is sustainable and a realistic approach to address climate change, this seems to be driving the matter. It's too popular to cause people to allow truth to be seen for what it is.
Many tragic outcomes in history have been driven by similar widely held delusional views, most famously to go full Godwin, the events in Germany in the period between 1933 and 1945, and more recently here in the US, Trumpism, and farther back in US history, the notion (still not completely gone) that dermal melanin concentrations above a certain level doomed human beings to be treated as if they were farm animals or worse.