Aw I actually love Harry. He's a nice balance against the egotists that make up most of the crew. Bright, even-keeled, reliable, funny, and willing to humor people like Tom Paris who is pretty much an unrestrained toddler. Dude should've been at least a full lieutenant by the time Voyager got home.
He's got no backbone, wines a lot, and remains immature throughout the seasons. Even in his old age the only progression he seemed to make was that he was more patient. He is just a sheltered shallow person, easily as narcissistic as the other main characters, just with lower self esteem.
He's a good wingman though. I'll give him that.
But I respect your opinion. I blame the writers. They did him a lot of injustices.