Isn’t there that story of him on a date just beating the shit out of his dog and not getting another date?

You’re right that charisma has little to do with morals, but I’d say Hitler is a prime example of someone only charismatic on stage. People who’d bought in entirely liked him, but he was no Heidrich or Eichmann.