He represents the darkest part of German history and brought great grief to the world. Fortunatelly most of the Germans today think so too and it would be a huge uproar here, quite rightly. Remember: Millions of innocent people died. I could not stand him being in the game.
I mean, I'm not really a fan of him either, but to play Devil's Advocate for a moment, 'killing a lot of innocent people' and 'bringing great grief to the world' are hardly unique traits to him. There are always lots of people in Civilization who aren't exactly squeaky-clean, as frankly there should be because the objective of Domination victories is in fact killing a lot of innocent people and bringing great grief to the world. We don't, for example, pretend the Manhattan Project did not exist -- and hell Nuclear Gandhi is an ancient meme, so great job respecting the Japanese civilian deaths there. Like, when you're actively using over two hundred thousand deaths
as a joke to the point of making it your chief representation of an entirely different country, you're not really in any place to pretend you're all that much better than a base warlord.
If we're going to completely bleach history and pretend that everyone was friends with each other forever, then good luck bringing back fan-favorite Genghis. And for all the hatred I see directed at Attila, 95% of it is aimed at his 'civilization' rather than him -- so much so that I went into the ongoing leader elimination battle purely to see how quickly he'd be eliminated on that basis alone, and I was not disappointed. I use them purely as examples, and you could pretty much toss any warmonger or general here and find that death is in their job description. You don't get to be "Scourge of Europe" just by building the Hanging Gardens. Hitler just happens to represent a market that's actually important in the modern age, so it makes more financial sense to whitewash Germany's actions and pretend they never did anything wrong than to force them to acknowledge what they brought onto the world.
I don't think he'd make a great leader for a number of reasons, especially not as a primary leader for a very multi-faceted country, but at the same time I can definitely see a lot of appeal when it comes to fighting against him (which is what you're doing with leaders ~7 times as often as playing as them) -- either on principle, in re-enactments of WWII, role-playing against one of history's most villainous characters, or what have you. But he's never going to happen because it's more financially important to keep Germany's reputation afloat than to acknowledge the people they killed (as dead people cannot buy Civ VI DLC), and it's consequently easier to gloss over the Holocaust and scrub Hitler from history than to actually force them to take responsibility for what they did.
Maybe they'll do the same thing with America this time and not give us any Native American civilizations so we don't have to feel bad about our history either.