I guess that depends on your world-view. I subscribe to the belief that it's the small, everyday interactions that determine the kind of person you are. It's one thing to be good or moral when making big, life defining choices or actions, but really the little things (even if it's just being thoughtful toward others in a video game) have just as much bearing on the formation of your character (your personality qualities, not your game avatar, lol.)
That being said, I personally don't hate hoarders. Well, scratch that, I do dislike a few of them but that is less about the fact that they have multiple homes and more about their personalities; I'm pretty specific with my hates, dislikes, likes, loves, etc. and I can't really form an opinion without knowing much about them. And I don't envy them either as I am already lucky enough to own a personal home and my FC has a house as well, and have passed on multiple opportunities to buy more. I simply don't want to because I don't think it's fair. Which is really the root of my issue with house hoarding- it offends my sense of fairness and just because it's not breaking the rules does not mean that it is not morally objectionable. Keeping multiple things for yourself, at the expense of other people, is objectively "not nice." This is something we teach (or try to) little pre-school aged children on a daily basis, it's a standard of social behavior; I really don't understand how it is suddenly so contentious, beyond people looking out for their own selfish interests.
You are correct in that I don't believe that SE can fix housing at this point, at least not with the budget they are currently allowed. I would love for them to completely overhaul the system and give us either instanced housing or dynamic wards but I genuinely believe that will never happen. Which is why I support stop-gaps intended to ease the housing crisis like the old auto-demo timer, the new 1/1 owning restrictions, and hopefully the future reclamation of hoarded homes. Everyone claimed that the auto-demo timer wouldn't make any difference either, but look how many people own homes now thanks to that. If they do reclaim the hoarded homes, I guarantee it'll make a huge difference to the people who are able to buy them.
As an aside, I really take issue with hoarders constantly throwing around the word "punishment" when talking about taking away their multiples. I've said it before and I'll say it again, being negatively impacted does not equate punishment. Losing those homes would be no more of a "punishment" by SE than they were "punishing" other players by holding them in the first place.