Yes, INTJs are often stereotyped as Palpatine style villains (hence my joke about the Devil). But there are plenty of heroes too - Batman, for instance. Or James Bond. Or more ambiguous characters like Snape in Harry Potter.

I'll have to look up ESFJ fictional characters now, out of interest. Molly Weasley from Harry Potter springs to mind as probably fitting the bill, for a start. And possibly Bilbo Baggins from The Hobbit.