There are some tropes I find tiresome, but really only if they’re misused. Unfortunately, as mentioned upthread, some of the most common ones like the MacGuffin and Chosen One are popular because they’ve worked well, but are often misused. The thing about both of these is that, yes, they don’t really exist in real life, but they do exist in so much of our mythology. This is exactly why the Chosen One works well in the original Star Wars trilogy, because Lucas was deliberately trying to evoke a lot of the elements from classical mythology to create a modern mythology. If he’d avoided the Chosen One or deliberately subverted it, I think the effect would have been lost.
Similarly, this is also why I think it works so well in the Matrix. Also as mentioned up thread, it is deliberately subverted in the sequels, but there’s a whole ton of hints in the first one that hint at it until they got heavy-handed with it in the sequels. For example, the assistant to the Oracle refers to the kids hanging out in her apartment as the other potentials, and the Oracle herself tells him “you’ve got the gift, but it looks like you’re waiting for something”. That is, all the rest of the people see her as a prophet, because they see her predictions come true and think destiny, meanwhile her, and as we learn later the Architect, are aware that these powers are a mathematical certainty. Hell, she told Morpheus he would find the One, and if he looked long enough, he either would, or he’d die trying. Even when Neo does become the One and he tells Morpheus that the Oracle said he wasn’t, rather than saying she was wrong, she was just telling him what he needed to hear. In short, she couldn’t be wrong, but she wasn’t seeing the future, she was just giving mathematically certain and unfalsifiable predictions. None of this would have worked if the trope didn’t exist.
That said, I do think it’s often misused. When you have the farmboy with the golden heart, then find out at the end that he was actually a prince the whole time, or decended from some powerful God or alien or whatever, I feel like it cheapens his accomplishments, and basically is a big FU, he actually WAS the Chosen One the whole time.
I feel much the same way with the MacGuffin, it works because of our mythology, whether it was just looking for enlightenment or the Holy Grail, it’s what sent our heroes on their quests. I think it works best when we don’t really notice it like, despite someone saying upthread there wasn’t one in Star Wars, there was, the Death Star plans were the MacGuffin. I think that works well precisely because we forget about it, where something like the Infinity Gems in the recent Marvel films seem a lot more heavy handed. However, I think that though are heavyhanded now, assuming the end game is the Infinity Gauntlet story line, I think seeing it develop across half a dozen films and then come to a climax in a future Avengers film will be really cool.
And it works well when it’s subverted too. As mentioned, I think Pulp Fiction toys with it a fair amount, keeping it interesting by not telling the audience what it is, where I’ve heard theories that it’s as plain as just a briefcase of gold, or stuff as bizarre as Wallace’s soul or the Holy Grail.
So, I do find the MacGuffin boring sometimes, particularly if it’s just some magical item to kill a bad guy or some really powerful weapon or whatever. If it’s going to drive a plot, I think it needs to be either something particularly special or at least an interesting twist, or it needs to be well worked into the plot so it’s more subtle.
That all said, the one I’m tired of that immediately makes me angry is the overly complex villain plot. One that really irritated me was the one in Skyfall. The villain is motivated to kill M, but passes up opportunities, gets caught, and then depends on someone letting his virus loose at just the right time to escape and get to the hearing to try to kill her there. Surely, a villain requiring the likes of James Bond to take him down could have come up with a plot to kill her that didn’t require so many unlikely things to line up. Especially since it basically ends with him just going after them hoping that with lots of men and guns he’ll win.
The Dark Knight sort of suffers from this, but at least there I could see it as a contingency, like, if he succeeds, he kills Dent, and if he fails and gets caught, at least he can get Lau. I could see him having the guy with the cell phone bomb in him in there regardless, killing Dent, then blowing that up and using that to get to Lau later or something. Then again, maybe I’m willing to believe it there a lot more because I love the film so much.
And, of course, there’s the opposite problem of the paper-thin villain. If all his motivation is that he wants to destroy the planet/universe or take over the planet/universe, particularly if he’s going to do it by getting some ultra-powerful MacGuffin or killing the One before he can stop him… meh. A bad villain can turn an otherwise great movie into a so-so movie. I want to see some decent motivation, and while I hate the overly complex plot, at least something more than than get powerful MacGuffin at all costs and win.