I’ve played video games too long to hate McGuffin plots.
Depending on the setting there’s not much difference between saving a town, the country, or the world. The bigger the stakes the more abstract it is. It’s hard to care about the world, or the whole friggin’ galaxy. You need to make the audience care about the characters in the world first so there’s some connection. That’s easier to do in a video game, book, or TV show. Way harder in a two hour movie, since you’ll probably just meet the main characters and maybe their boring family members.
I don’t care for prophecy plots, but I assume people like them because they want the world to make some sort of sense instead of being random things happening. Or maybe it’s the fantasy that their lives could be cosmically important. Similar to the cliche where it’s revealed the poor farm girl is actually a princess! Ugh. I hate that one. Obviously the protagonists can’t be some schlub, no, they need royal blood.
This is a popular view nowadays but I kinda disagree, depending on what sort of villain or story we’re talking about. I assume you mean straight up bad guy type of villains, not anti-villains or a gray and gray setting where everyone is a mix of both (like, say, Game of Thrones).
For sci-fi/fantasy/adventure, to me a good villain is 90% presentation. They gotta look cool, have the best lines, have interesting powers or influence, and as a bonus have a solid villain laugh.
Most real life villains are one dimensional and have straight forward goals or are delusional, mentally unstable, or religious fundamentalists. So to me, overly complex villain motivations with angsty back stories is kinda phony. And if it’s revealed the evil warlord has mommy issues he’s a lot less intimidating. Like how the prequels ruined Vader. He was a dude in black with a cool robot voice (even his breathing was badass), a laser sword, and he wore a freaking cape. Cliche as hell but still awesome and everyone still quotes him.
Or what about the Joker? What’s his super deep motivation? Guy fell in some chemicals and went bonkers. One of the best villains ever.
Or Annie Wilkes from Misery. It’s all in the little details, like hating profanity despite killing people and breaking legs or seeming to be kind and helpful until you realize she’s a complete psycho.
Anti-villains like Magneto (or other knight templar trope antagonists) are probably the most interesting, but the problem is if they’re done right you end up thinking the heroes are fighting on the wrong side.