I did like that, in the end, Tamaki fell for her because of her personality. Isn't that a good thing?

I see what you're saying, but I thought the point was that Haruhi was a very caring and considerate person. And the boys' interest makes sense, because she's a commoner and they're curious about her life. And she comes through for them as a great friend.