The most very Mary Sue characters will fail as part of winning. “Oh gosh, I flipped the evil villain’s wall switch that forced all the robots into hard mode - I guess instead of an underwhelming fight scene I now have to go full badass.” Basically their flaws are usually just vehicles for even more exaggerated strengths.