The Fade part of Dragon Age Origins. It was great when you explore it the first time, but after that it became a chore to collect all the item on a list.

I hate the part of Pokémon Go where you find Mew but it's in some nuclear bomb testing site.

Elden Ring. The experience as a whole has a significant drop once you take out Morgott. There's a handful of different reasons, and none of them are really significant, by themselves, but added all together...

Max Payne 1/2 dream sequences.

The new wolfenstein. My god so many cutscenes. Is it too much to ask to just have fun game mechanics/dynamics? I bought a game didn't I?

Anytime you need to fly a helicopter in GTA Vice City.

Everyone already mentioned Dark Souls and stuff like that. Some stages in classic Doom are also kinda like that.

But my personal nemesis is the mission Glatisant in Ace Combat Zero. Every AC game has it's long score attack missions, but Glatisant is mandatory in every run of a game you have to clear at least 3 times, and it's a 30 minute long ground assault on a snowy mountain range with poor visibility and covered in air defenses. The danger level never gets lower, and it's easy to get shot down right at the end and having to start it all over again.