The meaning of Mary Sue, that is agreed upon by everyone, is a character with no faults and is great at everything. The fact that the character used to name the trope is a woman, and was written by a woman, cannot be ignored. Plenty of characters that were great at everything came out long before this story, but we use this story to name the trope. Characters like superman and batman have like no flaws. Hell many characters in Star Trek could be considered Mary sue's, Spock and Kirk were represented without flaws in many (not all, but many) episodes. Yet for some reason we don't call this trope Bruce Wayne or Clark Kent or James t Kirk.
Also it seems strange to use the word female when talking about women. Like do you say that when talking to someone in public? Do you say male when talking about men?
Bruce Wayne?
A story I have brewing in the back of my head has a protagonist who looks like an adorable 12-year-old boy but is actually much older. As a professional actor he is always typecast as an adorable little boy instead of a snarky know it all, brat, or bully, and he and his friends like to think he is as sweet and innocent as his characters. He gets involved in an effort to bring down a major criminal organization, though being highly intelligent he tries to do so in the safest way possible like Nadrek of Palain Seven would. I never intended him to be any sort of commentary on Batman or an anti-Batman, but if anyone ever compares him to Batman he will be annoyed and horrified because his self image is all sweetness and light instead of dark, brooding, obsessive, unable to find happiness, life-wasting, vengeance-crazed vigilante like Batman. So not everyone considers Bruce Wayne totally admirable.
Bruce Wayne is not a perfect Mary Sue character.
Clark Kent?
Superman/Clark Kent has very high ethical standards in most incarnations. But I am not so sure about his common sense or intelligence. Getting a full time job at a major newspaper so he can hear about crimes and disasters is foolish. It is better to go without a full time job and tap into police and news radios and phone lines to know when he should spring into action to save the day.
I find it really annoying in the new Supergirl TV series that she has a full time job at Catco and a job with a government agency fighting criminal aliens. It is physically impossible for her to be in two places at once and logically necessary for her to be in two places at once to do her duties in both jobs. Therefore it is unethical for her to have those two jobs at the same time.
And therefore Clark Kent's job at the Daily Planet is also unethical. He can't do his duties in a full time job while also sneaking out to save people's lives whenever necessary. It is impossible for him to find time to do both. Therefore Clark Kent's double life is both sort of stupid and rather unethical.
Clark Kent is not a perfect Mary Sue character.
James T. Kirk?
I believe a main topic in each of the six TOS movies is Kirk struggling with his character flaws like obsessive desire for the Enterprise, fear of growing old, anti-Klingon hatred, being unable to settle down and have a family, etc.
James T. Kirk is not a perfect Mary Sue character.
Tim Thomason said:
Also James T. Kirk, Christopher Pike, Jean-Luc Picard, Will Riker, Will Decker, Gary Mitchell, John Christopher, Gary Seven, Mark Jameson, Bob Wesley, Robert April...
James T. Kirk?
See above.
Jean-Luc Picard?
Many people accuse Picard of being something of a pompous ass when talking about the superiority of Humans in his age to 20th century Humans. It seems to me that Picard is only right in statements that 24th century Humans are good and 20th century Humans are bad.
In "Tapestry" Q teaches Picard a lesson that Picard's daring and risk taking is what he needs to succeed as a captain. Even if a lesson taught by Q can be correct, that lesson is only valid about Picard's personal risk taking, not the risks he takes with the lives of those it is his duty to protect. In several episodes Picard neglects to separate the saucer section and leave it behind while investigating possibly dangerous situations, thus recklessly endangering the lives of civilians, including children.
Sometimes Picard's obedience to the Prime Directive seems evil.
Picard is not a perfect Mary Sue character.
Will Riker?
Riker and Pulaski murder unauthorized clones of themselves in "Up The Long Ladder". One murder is enough to make some less than a perfect Mary Sue character.
Riker is not a perfect Mary Sue character.
Gary Mitchell?
Gary didn't ask to be zapped by the galactic barrier. But if his normal human personality caused him to commit murder and attempted murder with his new superpowers, his normal human personality was evil.
I have always thought that I could have handled the superpowers of Charlie Evans and Gary Mitchell without going off the deep end and becoming a menace to society. And I'm certain that there must be some Humans, however few, that could have used those powers for good and not evil. Therefore Gary was not a perfect enough Human when it counted to be a Mary Sue.
Maybe the galactic barrier damaged Gary's brain and removed his ethical inhibitions. How did he behave before he was zapped by the barrier? He seemed to have good qualities and bad qualities. He was a little arrogant and contemptuous of his associates and was a skirt chaser like some proto-Kirk.
Gary Mitchell was not a perfect Mary Sue character.
As for the others, we don't know enough about them.