I think there are two explanations for it:

• the type of person that gets sufficient attention to be remembered long-term has a bit of a god complex
• everyone has good and bad parts, and each gets magnified in historical texts

It’s probably both in most cases.