I essentially agree with what you say, similarly
bweing's comment above but despite that committing scientific fraud is just such a risky business. If one falsifies results and the subject matter turns out to be irrelevant in the grand scheme of things one might get away with it because
it is irrelevant. — no one would care anyway. If it's high profile and contentious then one's likely to get caught out either sooner or later.
Let's take two cases. The Piltdown man fraud took place in 1912 and it wasn't until over 40 years later in the '50s that it was conclusively determined as a fraud, it then took about another 60 years to determine who the fraudster was. Right, the fraudster got away with the deception in his lifetime but he goes down in history with his reputation in tatters. Whether he considered this or not or perhaps he was hoping to be discovered and wanted to get himself in the history books when his name would otherwise be lost to history is a moot point.
Now to the infamous Jan Hendrik Schön https://en.m.wikipedia.org/wiki/Sch%C3%B6n_scandal. He was caught out quickly. My background is electronics so I understand what he did and I can say his chances of getting caught were damned high and he was caught. He must have known the risk he was taking, how could he not when the fraud was intrinsically recognizable by its nature? Then he makes his situation worse by virtue of repeating the fraud many times, so he was left without a 'plausible deniability' defense on grounds of a mistake/error/mix-up etc.
He's obviously not completely stupid or he wouldn't have been in that job. I'll rephrase that, he's not so stupid that he wouldn't recognize the risks. So why did he ruin his reputation? He deliberately shot himself in the foot without good reason—unless his reason was to become notorious.
People may think they can get away with faking data but if it's in a high profile field with others hanging off their results things will go pear-shaped very quickly. Remember, we've had excellent tools like Benford's Law for years and that's damned good at detecting forged data: https://en.m.wikipedia.org/wiki/Benford%27s_law.
Knowing what I know there's no way I'd risk my reputation faking data, I'd forever be living fear of being caught out. Moreover, I wouldn't do it for ethical reasons, as in the end I'd be not only cheating others but also myself.