In Phenomena; Ilke's adoration of mothers falls into this by being a huge Les Yay and implying that she Likes Older Women. It is understandable that she's desperate for a mother, growing up without any females to look up to for 10 years, but her line of 'Do all mothers smell this good?' is still pretty narmy, yet strangely adorable.
X-Wing Series: Certainly the newbie Tatooine pilot Gavin Darklighter's response to seeing Coruscant for the first time was narmy, but it helps illustrate just how young the kid is.
"It's just a city, the whole thing, one big, huge, really big city. It's all city."
Frank Peretti, a Christian horror writer, is very adept at the use of Narm Charm. Apparently, he realizes that his plots are extremely outlandish, and in order to avoid Narm he cranks up the absurdity of his situations Up to Eleven and lets you know it's okay to laugh through witty prose, thereby leading to situations — such as a town erupting into terrifying/hilarious chaos around a false Messiah — that are bizarre, hilarious, and somehow, really, really terrifying. Unfortunately, this does not translate well intothe film versions of his work.
Discussed with an internal example in Star Trek: Klingon Empire. The old animated show "Battlecruiser Vengeance" is this for many Klingons (and it's a nice wink to actual fans of Original SeriesStar Trek too). One particular episode presents the Klingon hero repelling a Federation boarding party. The episode was produced during the height of tensions between the empire and the Federation, and the party consists of ridiculous, inaccurate computer-generated images of Federation member races. Specifically, the Andorian is more green than blue and has overlong antennae, the Vulcan's ears are too pointed, the Tellarite looks more like an actual boar, the Betazoid has fully blacked-out eyes instead of simple dark irises, the Human has eyes too large and a mouth too small, the Trill has spots covering her entire body, and the Denobulan has misplaced ridges. In the minds of many "modern" fans, the inaccuracy just adds to the joy of it.
Harry Potter: This trope can definitely apply to the ending of the 7th book; after all the crap that The Trio has been through, you can't help but feel happy that everything turned out okay (for the most part) in the end... unless you're a fanatic Shipper and the ending defied your OTP; in that case, the ending of the series was your worst nightmare come true.
O'Brien: "How many fingers am I holding up, Winston?'"
Winston: "Four! Five! Four! Anything you like."
Room 101 itself works as an example. We've seen how lesser works have made the "your worst nightmare come to life" less scary than it should. Indeed, at first glance, the idea that, after months of the most devious psychological and physical torture known to man, the thing that breaks Winston is "give up your love, or get your face eaten by rats", still kinda sounds like something out of a Saw movie. But when you read it... it works, dammit.
From Lord of the Flies, the line "Roger sharpened a stick at both ends" should, by all rights, be laughable (what, is he going to trip and fall on it or something?) In context, however, it's the sign of the boys' complete degeneration into unbridled savagery.
Percy Jackson and the Olympians practically ran on this. It's a modern reimagination of Classical Mythology where scenarios like Zeus wearing a suit, Poseidon preferring khaki shorts or Apollo driving a sun bus while making haikus are all real. And fans love it.
Bluestar's encroaching mental illness in Warrior Cats. On the one hand, she's a fictional feral cat, so it's hard to cry for her. But on the other, she's an incredible leader and beloved friend who didn't deserve to live like that, dammit!
Brave New World - Aldous Huxley's writing style can come across as pretty hackey and/or lazy, but it's kind of endearing. It works well to bring the reader into a world that is (especially for the time of writing) quite difficult to buy into.