I think this is the wrong question. A better question would be “When, in a general election, has the less charismatic candidate triumphed?” The answers are not encouraging:
Obama was more charismatic than McCain and much more charismatic than Romney. He won both times.
Bush II may not have been particularly charismatic, but he was far more charismatic than Kerry and Gore. He won both times.
Clinton was much more charismatic than Bush I and Dole. He won both times.
Bush I vs Dukakis is debatable, but even if we grant that Bush I was an outlier, it doesn’t really matter much because when we go back further we see…
…Reagan was much more charismatic than Mondale and Carter. He won both times.
Carter was more charismatic than Ford. He won.
I don’t know enough about earlier candidates to offer an opinion one way or the other. However, I do know that, initially, the Nixon vs Kennedy race was a close-run thing…until Nixon debated Kennedy on TV.
Charisma is a huge factor in elections, so much so that if it came down to Hillary vs Trump, I wouldn’t necessarily count Trump out. He may have no sensible policies, no diplomacy, no sensitivity, no experience of Government, and so little brains he has to whistle when he goes to the toilet to remind himself which end to shit through, but he has charisma to burn. That’s undeniable. Hillary Clinton, if the debates I’ve seen are anything to go by, has less personality than an Excel spreadsheet. I don’t think that alone will be enough to undo her, but, when combined with her other negatives, it might just be the deciding factor, especially against an unusually charismatic character like Trump.