I feel like this is being too charitable to SBF and Holmes :-P They were always going to fail -- they were always going to get caught -- it was just a matter of when.
They were both stupid and short-sighted in a way that the others weren't. They weren't competent.
There was no outcome where they went down in history as good, but were actually bad.
---
I think most of the "fallen heroes" you list have done things competently -- sometimes amazingly competently -- but their behavior was terrible in some standout cases.
To take Gates as an example, he started a company that arguably made the computing world worse off for a couple decades with anti-competitive tactics. He arguably "stole" a lot of money from his competitors.
Microsoft treats a lot of their enterprise customers like shit (but that's not a crime).
But I don't think Microsoft was at its core a fraudulent company (I personally avoid most of their products -- but then again I avoid a lot of software companies). It may have been bad, but at the end of the day there was and is an actual business there. It's qualitatively different than the frauds.
(Also, Microsoft arguably "invented" the idea of selling software (without hardware), which unlocked a lot of value. They were very early to the game. And, the more we learn, there seems to be less and less light between Google in the last 10 years and Microsft in the 90's. I also don't consider Google fraudulent at its core, though it's been taken over by bad actors.)
---
SBF is a lot closer to say Bernie Madoff. Madoff just took people's money and literally never invested it. He just had a computer program print up reports that showed 25% a year gains. He was running a confidence game.
SBF was maybe a hair better than that, since I guess he did actually perform crypto trades lol. (But if he had Madoff's regulatory access, he probably wouldn't have)
Either way, not much better. He sent the same kind of fabricated reports, and made up safeguards out of thin air, and he didn't produce anything positive to compensate for it. It was a pure loss for everyone!