Let's assess a few performances in an imminent battle against a superior firepower:
ST'09: Enterprise saved from destruction by Narada only because Nero recognizes ship and wants to reach Spock.
This assumes that fight would have ended in sure defeat for the Enterprise, which is far from a foregone conclusion; Enterprise is more advanced than the Kelvin or any of the other ships that got sucker punched coming out of warp. Apart from this, Narada also has its drill deployed, which limits its maneuvering options in a fight. If Enterprise was at least as effective as the Kelvin in combat, the battle would have ended with a dead Enterprise and an equally dead or crippled Narada.
But it wasn't Nero's gloating that lead to his downfall in the end. It was the combination of Scotty's skill at the transporter console (despite his relatively poor aim) and Kirk and Spock managing to fight their way through Nero's crew to hijack the jellyfish that won the day. Enterprise's weapons turned out to be way less useful than Kirk and Spock's creativity.
STiD: (where's the scientific ingenuity?).
In realizing that Spock Prime might be able to confirm his suspicions about Khan, and in realizing that Khan's single-mindnedness is an exploitable weakness; also, in figuring out that the torpedoes are set to detonate if tampered with and that particular feature can ALSO be used to his advantage.
STB: Swarm decisively destroys Enterprise, Spock is critically injured, saved by McCoy...
Who then regroups with Spock and Scotty and the rest of the crew, who proceed to salvage a 100 year old derelict starship and subsequently use their experience with the swarm's movement and tactics to DESTROY THE ENTIRE FORMATION.
STB is actually the ultimate proof of this concept: even with the Enterprise completely blown to smithereens, even armed with token weapons a century obsolete, they STILL managed to outsmart and defeat their enemy.
In this case, the Enterprise was indeed saved by the science officer in ST09, but not because he outsmarted the opposing weaponry.
Nope. He outsmarted the opposing COMMANDERS.
Which is Starfleet's entire MO. Where the Klingons and the Romulans have to depend on overwhelming force to give themselves an advantage, Starfleet manages to topple militarily superior opponents left and right by applying just the right amount of force at their weakest point. It's the MAIN reason why they're as successful as they are: they don't have to WIN a fight, they just have to make it impossible for their enemy to fight at all. Picard probably couldn't take Duras in a bat'leth match, but he can dodge his attacks long enough to create an opening, take a quick jab and dislocate Duras' elbow, turning what should be a sword duel into a farce.