Mac: Goo, I'm really sorry for what I said about you. You're not weird. You're really creative and funny and nice, and if you're not too mad at me, I really wanna be your friend too.
Axis Powers Hetalia: 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).
Bleach: Ichigo and Rukia have shades of this at the beginning of the manga, since Rukia hasn't lived in the human world in years and drives Ichigo crazy with some of her socially odd antics. As the plot moves towards the supernatural slice of life, however, the dynamics tend to either fade away in the plot or be taken in a somewhat more serious way.
Ulquiorra and Orihime, in a dark way, since a) they're enemies, and b) he has almost no grasp of emotions and thus has a tendency to speak to her rather caustically, which inevitably contributes to Orihime's Break the Cutie process. The comic in UNMASKED has them interacting in an almost-typical version of this, with her being bubbly and happy and him just taking it in stride.
Orihime and either Ichigo or Ishida kinda fit as well, and so do Ichigo and Senna from the Non Serial Movies.
Kenpachi and Yachiru are sort-of father/daughter version.
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.
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.
Naruto: Shikamaru and either of the girls he is most paired with fit this trope. Temari and Ino are both far more aggressive than he is. Both tell him to "man up" or push him to be stop being lazy.
A non-romantic version has Kirino and her brother Kyosuke from Ore Imo.
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.
Similar to the Chrono Crusade example above Tomoe from Kamisama Kiss is a lot stronger than Nanami but thanks to the magic contract between them he is forced to obey her.
Comic Books
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).
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.
The first time Emily Friehl meets Oliver Martin in A Lot Like Love, he tells her that in six years he plans to be settled and content in both life and career while she lives life by the moment.
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.
Gilmore Girls: Luke and Lorelai own this trope, even when they weren't a couple.
Lorelai's neighbors are cool, calm, and collected Morey and his loud and gossipy wife Babette.
Lorelai had this relationship with most of her romantic interests. In fact, Max and Lorelai probably didn't stay together because he couldn't keep up with her, as Dean noted.
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.
Anthony Bourdain went to South Korea. His assistant Nari Kye, who actually is from Korea and has several family members there, went with him Hilarity ensued.
Ryan and Kelly were this in the early seasons of The Office.
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.
Theater
Emmett and Elle in Legally Blonde: The Musical; less so in the movies, but still there.
Fire Emblem has MANY of these: Erk and Serra, Oswin and Serra, Lowen and Rebecca, Rhys and Mia, Azel and Tiltyu, Shannan and Patty/Daisy, Lalam and Roy, Rennac and L'Arachel...
Keiji and Kasumi in Mass Effect 2, though since Keiji died before the story began the only screen time we get is a recording of a message for Kasumi.
Nice!Hawke and Isabela in Dragon Age II, or Silly!Hawke and either Anders or Fenris.
Aggressive!Hawke and Merrill have some shades as well.
And Alistair and the Warden can be this in Origins.
So can Leliana and a more level-headed Warden.
Valkyria Chronicles: Homer Pieron and Edy Nelson. Although she's more of a Leeroy Jenkins rather than dumb, and he's mostly lucid until one appeals to his masochistic side.
Vincent Valentine and Yuffie Kisaragi in the Final Fantasy Compilations, especially Dirge of Cerberus. Whether their relationship is romantic is a matter of speculation.
Exactly the other way round with the "Little Conqueror" Sun Ce and Da Qiao. Actually, Sun Ce - Zhou Yu and Da Qiao - Xiao Qiao also qualify (without actual pairing, of course).
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.
Visual Novels
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.
More like Sarcastic Guy Energetic Girl, since he's not had too much experience, but Conrad and Toni from Hanna Is Not a Boy's Name count for their shippers.
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.