Chrono and Rosette in Chrono Crusade, although with a few slight variations. For one thing, Chrono is actually stronger than Rosette, but since their contract means his powers take time away from Rosette's lifespan, Chrono prefers to let Rosette take the lead in combat situations and only uses his true power as a back-up plan. And for another, while Chrono comes across as much more rational than Rosette, it's actually only because Rosette is veryHot-Blooded and impulsive, and Chrono has much more experience than she does. When he's matching wits with someone closer to his true age, Chrono comes across as someone with average intelligence and much more impulsive and emotional than is obvious when he's with Rosette.
Code Geass: Lelouch Lamperouge and nearly any girl he can be paired with, because Lelouch is a Squishy Wizard of sorts. Even his own little sister is shown to be more energetic than him. (Which is even more hilarious when you realize that said little sister is paraplegic at the time of the series itself.)
C.C., however, the girl he spends the most time with overall, is at most a downplayed example. Granted, she's still doubtless more energetic than the endlessly cerebral Lelouch, and has a bit of a penchant for mischief (usually of the kind intended to give Lelouch a heart attack), but her typical demeanour is aloof and snarky, averting this trope for the most part.
Death Note: Light Yagami and Misa Amane, but Light never loves Misa although he shows concern for her well-being when suffering from his self-inflicted amnesia.
Ginta and Koyuki have something resembling this in MÄR. He's not super-smart, just kinda geeky and to some extend anti-social. She's pretty energetic and pretty much the only kid around to give him the time of day.
Tower of God: Yuri Zahard is a princess who does whatever she wants. Evan Edrok is a high ranker and and well-respected guide (also very short). She drags him to the bottom of the tower (World Building in a very literal sense) just to see a new irregular.
Yu-Gi-Oh!: While they never go beyond subtext, since the series (especially the anime) thrives on Ship Tease, Mahaado and his student Mana fit this trope quite well. About the only point missing is the Squishy Wizard status, since Mahaado is well trained both in magic and military arts.
Yu-Gi-Oh! 5Ds has Jack and Carly. While he doesn't fit the "soft" attribute (being quite physically adept), he's very aloof and scornful of friendships. She's very excitable and clumsy and is probably the only person in the series who has gotten Jack to attend a social event that didn't involve dueling.
Deconstructed in Young Liars. Sadie acts the way she does because a bullet in her head destroyed her inhibitions and ability to recognize consequences. Danny was her stalker prior to the shooting, and since then has taken advantage of it to make her completely dependent on him.
Lois Lane and Clark Kent are possibly the Ur Example of this trope, definitely so in the genre of comics. Doesn't completely apply to Lois and Superman, however.
Tim Drake/Robin (goal-orientated serious introvert) with Stephanie Brown/Spoiler (plucky, street smart people person).
This is the dynamic between Lacey and Tirra of Tales from the Fleet. Though it's really more of Savvy Girl, Energetic Girl—or, if you really want to get specific, Savvy Human Girl, Energetic Aurin Girl.
Tangled: After Flynn and Rapunzel leave the tower to see the lanterns, Rapunzel has major conflicting feelings of excitement to finally see the world, and guilt for disobeying her mother's orders of staying in the tower. Trying to ease her conscience Flynn tells her that this is just a part of growing up. A little adventure, a little rebellion... that's good. Healthy, even.
This defines Anna and Kristoff's relationship in Frozen nicely. She is a spunky princess willing to do whatever it takes to bring her sister home, he is a grumpy, rough-around-the-edges ice harvester helping her along the way.
In 1948, Alice and Jasper met in a small diner in Philadelphia, Pennsylvania. Alice approached him as if they were already close friends and told him that he'd kept her waiting a long time. Jasper was mystified and wary, but his ability to feel Alice's joyful emotions impacted him greatly, which allowed him to take her hand when she held it out, saying that, "For the first time in a century, I felt hope." He then learned to reciprocate her feelings.
Smallville features Clark Kent and Lois Lane in this role. Clark is more stoic and reserved, but tends to be a little clumsy, while Lois is an energetic talker who tends to be very outgoing most of the time. Of course, the 'a little clumsy' thing is, as always, so nobody'll connect Clark with the mysterious "red and blue blur" who goes around righting wrongs.
In the early seasons of Angel, Wesley and Cordelia have this dynamic.
Degrassi pulls this off with the brooding goth Eli and the zany unconventional Imogen, moreso while she's his Perky Female Minion as she's worrying about him too much when they were an official couple. Sunnyshine and happiness Becky played the platonic version with Eli, and the romantic version with Adam. Although there it was more about energy than about ditzy or airheaded.
Two of the minor Masters participating in Fate/EXTRA's Holy Grail War. Having entered as a couple on the girl's suggestion, they find the rules prevent them from becoming a Battle Couple as she originally planned. The boyfriend realizes the full implications of what they've gotten themselves into much sooner, while the girl remains cheerful, optimistic and sunny.
Legend of Heroes: Trails in the Sky - Estelle and Joshua, though I wouldn't call Joshua physically inept. He IS a bracer, after all. He just prefers reading a book to hiking or fishing.
Borderlands 2 has Roland and Lilith. While Roland is straightforward and seemingly humorless, Lilith is snarky and outgoing. In this case, it's a rare example of exes, though they separated mainly due to their war with Handsome Jack getting in the way and the two still care about each other.
The Professor Layton series, in the second arc, pairs the Professor with EmmyAltava. She packs some serious martial arts skill to complement the Professor's sharp mind. Although the Professor himself is no slouch in a fight, and Emmy solves puzzles just as easily, they do fit the trope.
Ace Attorney: Phoenix Wright and Maya Fey (or Ema Skye), and his successor Apollo with Trucy. Even more so with Miles Edgeworth and Kay Faraday, since Edgeworth's supposed to be extremely competent at what he does.
The Austro-Hungarian Empire. Also, two Ho Yay versions: Germany and Italy, and England and America.
Taiwan is this to China in a Drama CD, where they have a rather... weird interaction (She lectures him for being Totally Radical and loud, then ends up breaking his arm while attempting to fix his back). In the fourth volume she's the energetic girl to pretty much everyone in Asia, whether males (China, Japan, HK, Macau) or females (Vietnam).
Roy and Celia from The Order of the Stick fit this description, though it's worth noting that this is an example where the girl isn't any less intelligent than the guy, just not as down-to-earth (pun not intended); at worst, Celia is just a little naïve when it comes to humans, what with her being a sylph and all.
Doki and Nabi from There she is!!. Also, he's a cat and she's a rabbit.
With superheroes the key part of the Whateley Universe, it happens all the time. Jade Sinclair (Generator) and Stephen Lee (Thuban). Toni Chandler (Chaka) and Scott Emerson (Thunderbird). Anna Parsons (Aquerna) and Jerry Walsh (Hazmat). Since Hazmat is an inventor and Aquerna is a bubbly babbler with squirrel powers, they may be the classic example so far.
Quincy Bolthouse and Megan Kher from the Playdom game Gardens of Time. Megan is more of a Naïve Newcomer than The Ditz, though, and she has a huge crush on Quincy that he's oblivious to. For a while, anyway.