Legend of Zelda: Wind Waker (Which just turned a decade old this month)
The beginning features a place called Forsaken Fortress. You get shot out of a cannon to get inside, and lose your sword due to smacking into a wall. You need to endure a somewhat lengthy stealth segment to reach the top, the worst part being the hallways that you need to sneak around in a barrel. If the Moblins see you move, you get tossed into a jail cell and have to escape over and over. It's like Metal Gear Solid done terribly wrong. But at long last, when you reach the damn top, you get your sword back and you get to hear some awesome mini boss music. Later on, you go through it again (without the stealth) and get to slaughter those Moblins with the Master Sword.
Deus Ex: Human Revolution
The boss fights. Everything else felt, for the most part, like what a modernized Deus Ex experience would feel like. Unfortunately, the boss fights are shite. You cannot avoid them with the usage of stealth or diplomacy like you could in the original. They stick out like a sore thumb and play bizarrely. Eidos outsourced the boss battles to a separate company who didn't know Deus Ex in the slightest, and the particular man responsible described himself in an interview as "more of a shooter kind of guy". Well, the first boss battle is against somebody with fucking machine gun arms that you're forced to fight in a rather sloppy nature. Go figure.
All Mass Effect titles
The first game had the Mako segments. Bounce around barren planets like a right loon to find stuff. Boring.
The second game had planet scanning and the usage of probes to gather resources. Boring.
Third game had the second game's mechanic, but made it worse.
This is just scraping the surface of these games.
Any game that uses QUICK TIME EVENTS
Those things are rubbish, stop it.
Either I'm playing, or I'm watching. Choose one.