As i recall from being a Believer, the single most important theme in Christainity is redemption. A second chance. Jesus offered it to us. Redemption is a really interesting and powerful literary theme. The ultimate in character development. Going from the guy that would push the button on the orphan-crushing-machine to the guy who’d die to keep people away from that button…
That’s why i used to get so bored in D&D games where the DM or anothe rplayer would insist that my character wouldn’t do something because his alignment was written in stone.
Also, the fact that the trope exists offers an opportunity for play. There’s a novel about an Orc war party that gains access to US Marine weapons and becomes an impressive army. And EVERY TIME you start to suspect these heartless, cruel, baby-eating monsters are about to turn good, the author says, ‘HA! I’ll teach YOU to let your guard down.”
A lieutenant orc sacrifices herself for the commander. He looks at her corpse, thinks of the years they’ve been together, the battles they’ve survived. Then he rips her ear off and chews it while walking away. “Tough old bitch,” he comments.
“There has never been a story with an outright demon as a good guy that wasn't complete garbage”
Somehow, i doubt you’ve come to that conclusion based on the literary elements and an objective analysis of the writing. So, stuff a patrol sock in it, you’re less useful as a reviewer than as a gatekeeper for ‘proper’ assumptions.’
“it always involves overturning Good and Evil in ways that turn the story into an incoherent mess.”
It’s fiction. Meant to explore ideas, not reinforce the only acceptable ideology.
You probably hate all the slash fiction where Vulcans are gay 98.827% of the time, and only turn straight during mating season.