Harry, who had previously been presented mostly as a kid being kept away from the action by his understandably protective father, Thor (he was incarnated as James Potter), is kidnapped by the Disir, horrors that took an Allfather to banish, at the end of chapter 33. He then spends chapter 34, aptly titled 'Fool's Gambit', he pulls Indy Ploy after Indy Ploy to get himself and the other kids kidnapped with him away from them and to somewhere they can call on Heimdall. They get away without taking a scratch.
Harry, Diana, Uhtred, Carol and Jean-Paul do this in chapters 59 and 60, particularly the latter two, who haven't had any known combat training or combat experience. First, when trapped on a mountain (which just so happens to be a powerful and thoroughly pissed off Genius Loci) and caught in a massive blizzard caused, in part, by a terrified 11 year old Bobby Drake, they manage to find the person in question by Uhtred's Scarily Competent Tracker skills, despite the weather and attempts by one of the Slendermen (Winter Fae mercenaries) to waylay them. Then, following a temporary Plot-Relevant Age-Up, they take on all comers, primarily demonically enhanced werewolves to protect Bobby who HYDRA are after, with Harry boring a hole in a mountain several miles away with a 'small' fireblast. And when HYDRA send in their trump card, a copy of the Destroyer remotely piloted by Baron Zemo, Diana winds up ripping it in half.
Harry does this again in chapter 70 when in his second real fight (the first was rather brief) when he isn't simply buying time to get away or given a temporary Plot-Relevant Age-Up to his adult self, charging head on into a massive HYDRA assault force and tearing them to shreds. Unfortunately, he's a Glass Cannon and runs up against Daken, who succeeds in killing him. Briefly. After this final episode of Break the Cutie, he remains consistently dangerous and faintly terrifying.
Also in the same chapter, Warren's spent most of the last 20 chapters moping over his Razor Wings, and generally being dismissed as pretty, but useless, Sean's pet project and largely being the Straight Man to Sean's Wise Guy. In any case, it's sufficient to make the reader forget his earlier dismantling of multiple Dracoliches during the Battle of the M4. Then, when HYDRA attack Hogwarts, he reminds both readers and cast of how terrifyingly deadly he is by unleashing a Mook Horror Show straight out of the gorier parts of the Old Testament and almost singlehandedly slaughtering the entirety of HYDRA's aerial attack force wearing only a pair of pyjama bottoms. The half-mad last mook standing explicitly compares him to an angel of death, and it isn't in the least unwarranted.
In The Wizard in the Shadows, at the final battle of the Black Gate, all seems lost. Harry, the most powerful weapon in the arsenal of the Light, is dead, the Sword of Gryffindor that allowed him to draw on impossible amounts of power is inert, and the forces of good are sorely outnumbered. Then Ginny — up until this point merely quite powerful — picks up the Sword and says a Little "No". The Sword responds. Cue three giant tornadoes of fire and a whole world of hurt being laid on Mordor's forces.
Rise of the Galeforces: Everyone.Just...everyone.Special mention goes to Violet in particular, since her finally being allowed to cut loose and demonstrate to the bad guys what she is truly capable of is pretty much the reason the fanfic itself manages to outlast all the hell it gets put through.
In the Pony POV SeriesDark World timeline, Derpy Hooves has spent a thousand years cursed to walk around Discord's castle until she does it enough times to earn her children's freedom from their own curses, all while being constantly attacked by a murder of blackbirds that are trying to eat Dinky (who's been turned into a muffin). She does this without a single complaint, staying focused on her task... until Twilight and the other redeemed Elements of Harmony convince her to help fight against Discord in order to save Dinky and Sparkler without abiding by Discord's fixed rules. Derpy then proceeds to prove her worth as the new Element of Loyalty by helping to fight the blackbirds, playing a key role in defeating them.
She does it again in the fight against the Valeyard. She spends most of the fight holding back due to the Valeyard being a Discorded Doctor, but when he eventually pushes her too far and she finds out he's actually the Doctor's Super-Powered Evil Side, she then proceeds to go into a Tranquil Fury and beat him to death, ensuring that he'll change back into the Doctor.
This is pretty much a major aspect of her character; when there's not a fight to be done, she's a kindhearted Ditz, but once her friends or children are in trouble, she gets serious and is more than capable of kicking flank.
Back in the main timeline, the Crusaders do this during the Wedding Arc, in response to Sweetie Belle and Spike getting brainwashed — despite just being fillies, they manage to sneak past the Changelings, knock two out, snap Spike out of it, and then cover their escape by summoning a water elemental. Heck, the whole reason the adults let them help anyway is because they can tell by how determined they are to help that they'd do it even without permission anyway, plus, with the amount of stuff they get up to and survive on a regular basis, them taking things seriously makes them an actual threat.
In the Buffy the Vampire Slayer / Power Girl crossover Origin Story, Alex Harris (a Kryptonian trapped in the Marvel Universe) and her domestic partner Louise are attacked by the telepathic assassin Typhoid Mary. Mary knocks down Louise, then turns her attention to Alex and proceeds to use her mental powers (against which Alex has no defenses) to wreck Alex. Turns out ignoring the normal, untrained girlfriend was a mistake when Louise proceeds to clock Typhoid Mary from behind with a bottle of sparkling grape juice, then continues to beat the assassin with it until Mary is unconscious and bleeding on the floor.
At the beginning of The Celestial Renegade in Sailor Moon: Legends of Lightstorm, this is the reason Luna takes Sailor Moon to Lightstorm. Lightstorm causes this to happen with Sailor Moon over the course of a single afternoon. And that was before he came to Tokyo and began training the rest of the Scouts.
In How Trixie (Somehow) Saved Hearth's Warming, Trixie is her normal hammy, bragging self and just manages to skirt by in the situation she's gotten herself into (namely saving Hearth's Warming) by being Mistaken for Badass. However, after being turned into a nutcracker by the Rat King, she goes into a Heroic B.S.O.D. until she finds out Vixen was desperately trying to finally stand out among the rest of Santa's reindeer and is having a Heroic B.S.O.D. as a result of their capture. Trixie quickly realizes this means the two of them are Not So Different, both feeling Overshadowed by Awesome by somepony else and just wanting to stand out. This realization causes Trixie to snap out of it and devote everything she has to getting them through this. She ultimately stages a prison break and defeats the Rat King via quick thinking and plenty of Indy Ploy, saving not only the two of them but all the Rat King's slaves. Even Trixie is surprised.
Havoc does this in the Elemental Chess Trilogy. Just like in Fullmetal Alchemist, he's a bit goofy and loves to make jokes, and has a powerful nostalgic streak. When things go south for his beloved commanding officers, however, he steps up and takes charge, reminding everyone just why he's one of Roy Mustang's most trusted subordinates.
Once More with Feeling: Shinji used to be wimpy and non-confrontational, but after returning to the past, being aware of what will happen if he fails, he is way more dangerous and fights like a berserker.
The Inquisitors have a few moments like this in All This Sh*t is Twice as Weird, such as when they learn that some of their soldiers have been taken prisoner in the Fallow Mire and when they're fighting to get out of the Fade.