No one thinks he was good. He and his cronies did immeasurable damage to US prestige and treasury.
But he wasn't openly in league with hostile powers, wasn't blatantly corrupt, and didn't utterly meltdown when faced with a crisis. Arguably, this is because Chaney and other Neo-Cons were calling the shots, but things seemed mostly stable.
Trump is all of those negatives but without the veneer of good faith and competency.