Don't forget Wesley Crusher. I don't know why people pretend that the male version isn't also disliked, but I don't think it's a rational stance. People don't like either.
Other characters on the show find Wesley obnoxious, and he nearly washes out of Starfleet Academy after covering up a stunt that killed one of his friends. I don't see him as a wish-fulfillment character at all.
He is for a long time. Everyone likes him; he's an extremely high achiever; he easily impresses a beautiful girl, and in the same episode outwits all of the Enterprise's security staff to save the Enterprise; he even has special powers that somehow make him a more advanced iteration of the human species.