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.
In the Czech movie, Koyla, part of the plot involves Koyla's grandmother dying, Louka tells him that she is only sleeping as the boy is only five years old at the time. Later in the movie, there is the scene where Kolya is in the bath, uses the shower head like a telephone and tries to speak with his grandmother. It seems a bit ridiculous, but is genuinely sad because of how very upset he.
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.
And the ever-famous, ever-badass, "NOT MY DAUGHTER, YOU BITCH!" courtesy of Molly Weasley.
1984. This conversation was used in the climax of the story. At first it seems to be a trivial discussion about counting fingers, but it's actually about a man being tortured into changing his perspective in order to see things that aren't there. Some might say it's worse than Room 101 itself.
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.
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!