I genuinely think it's supposed to be a problematic character trait, considering how often and how spectacularly it gets Harry in trouble, and how much the women in the books comment on it.

Also, there are some really awesome women in the series. Molly & Murphy are winners. (I would add that a lot of the men are actually described in terms of their attractiveness, also, which doesn't pop up much in books authored by men.)