I love the original Hotline Miami but I’m not a big fan of the boss fights like the ones in Neighbors (Biker) and Deadline (Van Driver). I find it kind of slows down the game and limits the strategies you can take.
Another example would be Fallout 3. I find the tutorial section in Vault 101 can feel a bit long after a fifth run but maybe that’s because I was spoiled by Fallout New Vegas’ ability to run off in your own direction immediately after leaving Doc Mitchell’s house.
Every mandatory stealth section in a non-stealth game. Spider-Man, several Zelda games, Metroid Dread, Jedi Knight II.
I loved the stealth sections in ocarina of time and wind waker
Interestingly, i used to hate the stealth section in wind waker as a kid, and now it feels like no big deal. I attribute this to being older and now sort of decent at games.