I love redemption arcs for victims of abuse. I think they serve as a wonderful message. A beacon of hope. But not every abuse victim has to be redeemed. Especially in a show that has other victims of abuse who break the cycle, it's fine to have a character who doesn't. It's sad but it also serves as a message to kids.
Harry is someone who feels a tremendous amount of guilt over being alive. He has never gotten over the fact that his parents died for him. His mother would still be alive if she stepped aside. And through the years, numerous people have risked their lives for him. And even when they don't risk their life for him, like with the people who fought Voldemort and died, if they're close to him, he will still feel guilt.
He's an intriguing character and as much as I dislike him, I don't think there's anything wrong with you if you like him. He's a gray character so it makes sense for the fandom to be divided.
If you solely watched the movies and never got to experience the pure joy that is book Hermione, you wouldn't know what an absolute menace she is. Sure, she may seem like a sweet little nerd at first. But get on her bad side, and she's not above committing war crimes to put you in your place.
And yes, while it is revealed that Sirius Black was innocent, this is the first book with no real happy ending. There is no justice. And even when Sirius Black, the supposed murderer escapes, the minister for magic is more concerned over his reputation than the risk to his people.
And then you have "Harry Potter And The Chamber Of Secrets". The stakes are slightly higher here. A little girl gets kidnapped. Harry discovers that some adults are actually really stupid. But he still manages to defeat Voldemort yet again. He's allowed to succeed and return home, knowing that he saved the lives of countless.
But as an abused child, he is easy to manipulate. He doesn't notice when he's a pawn in someone's scheme because there really is no one checking to make sure he's treated well. If Harry Potter was killed at Hogwarts, Dumbledore wouldn't have to worry about his family making a fuss.
They may be sworn enemies. But that doesn't matter when it comes to your soulmate. When you find that other half of your heart, when you find the one who matches you in every way, you can't help but fall in love. And I love that in the end, what brought them together wasn't magic but rather their own choices.
And reading the Kyoshi novels really puts that into perspective. Korra didn’t ruin Aang’s characterisation. It simply revealed the nature of the Avatar cycle. Even Yangchen created problems for the avatar that came after her.