Your Fave is Problematic

And we wouldn't have it any other way. I think that we as an audience like having flawed heroes because it humanizes them and enables us to identify with them. It's hard for viewers to do so with a hero who is underdeveloped or perceived to be perfect. However, this can make for some interesting character development if the too-perfect characters display a different side to them or have it revealed that something happened to them that made them pretend to be perfect.

Dumbledore is a great example of a deeply flawed character who already went through character development by the time we meet him. He was the most brilliant student Hogwarts had ever seen, but he was the son of a broken family; his sister Ariana was rendered mentally, emotionally, and magically unstable due to an attack by Muggle boys, and his father attacked them and was sentenced to Azkaban. Upon graduating he intended to leave his family, but his mother was killed by Ariana's magic, making him the family head. Deeply resentful of the situation, he felt his talent was wasted.

This hunger for recognition would eventually backfire on him when he met Gellert Grindelwald, a wizard his own age who also possessed remarkable talent. He became "fascinated" by Gellert's ideas of "wizarding domination", seeing it as a second chance to "show off his own talent", but when they were about to leave together his brother Aberforth confronted him over his neglect of Ariana. Grindelwald in response inflicted the Cruciatus Curse on him; a duel erupted between the three of them, and Ariana was killed in the crossfire. Grindelwald fled, leaving Dumbledore behind.

Fortunately, Grindelwald's retreat made Dumbledore come to realize that "power was his weakness and temptation" and thus did not actively search for it, making him a deeply flawed hero who is ultimately likable.