I’d like to propose a different perspective.
In my opinion, the root at the OP is the separation of good and evil in the Abrahamic religions belief system. This is in turn drives the western system of values and ethics.
Per this system, whether it be Moses, or Jesus or Mohamed (PBUH), they are all good and no part of them is bad. God is everything good and the Devil is everything bad. So this model shapes the value system and ethics of the thought processes of the western society, in general. This is also the value system used to judge personalities.
Contrast that with the eastern mythology / belief system. Rama (one of the Hindu gods/avatars) is criticized for being a MCP and unfair to his wife, Krishna is criticized for being a womanizer, and Buddha is criticized for the unfair treatment of his wife. Even Gods have their character flaws and are not exempt from shortcomings. The idea there is that everyone has flaws and there is no universal one person or one personality that people will worship or lay accolades on.
This by extension leads to what the west loosely calls polytheism. But at heart, this is about people choosing their role models or heroes or even God(s). There is no one size fits all,  forever. A hero to one maybe a villain to another and that can also change over time.
For example, Columbus was a great guy and an utterly despicable guy depending on which side of the fence you are on. The side for which Columbus is a hero, brushes off his shortcomings as the prevailing morality of the time. The other side sees him as a complete villain with no redeeming qualities no matter the time when the brutality was committed.
Whether a wrongdoing was committed because of prevailing morality or deliberate villainy, to the group negatively impacted, it’s a distinction without a difference.
In my opinion, the Columbus supporters have to acknowledge his faults, make amends where possible, and realize that their hero has been a villain to some. Similarly, the Columbus haters need to acknowledge his accomplishments, give praise where due and realize that the villain is hero to some.
So, the very premise of futureproofing or even presentproofing one’s personality is flawed. One should do the best they can based on what they feel is right for them. At the same time, society in general should move away from the value system of perfect good/bad. In my opinion, there will be no universal heroes or villains. Different groups of people will have different heroes and will have to acknowledge that their heroes had a dark side too.