The reason characters in videogames are attractive is the exact same reason why actors are attractive. People like to look at things that are attractive.
I don't see anything wrong with it and I vehemently disagree with the idea that it takes resources away from a game. I don't think it takes resources away from a game to make a not attractive character either. I think it really is just a natural preference to like to look at someone who is attractive. Having someone who isn't attractive can help with relatability for people who aren't, however.
I really don't think it should matter much.