THOSE Moments in Games

So today I'm playing Etrian Odyssey on the DS, a cool little dungeon crawl that involves drawing your own map and exploring a vast network of tunnels filled with equal parts treasure and danger.  I thought this game was pretty awesome until I got a certain side-quest, a side quest to spend 5 in game days on the 8th floor of the dungeon. 

That means moving 3600 steps, which means patrolling in that 3 square little space for 5 game days because otherwise I have to fight boring monsters that I can kill in one hit!

This got me thinking, there are a lot of games that have THOSE moments, you know the ones I mean, the moments that throw a dirty big wrench into an otherwise really enjoyable game.  The most famous example that comes to my mind is the Ocarina of Time Water Temple

People love the shit out of this game but this dungeon is one of the most hated things in all of gaming. 

While most of these sections usually involve a sewer, this doesn't quite qualify as a rant on sewer levels because there are a good handful of games where these sections take place outside of those infernal underground pieces of shit.

The problem with these sections is that it can really kill the replay value of a game.  There are plenty of games in my collection that I would actually love to play again, but as soon as I go to play it, I remember THAT bit and suddenly I don't want to play anymore.  I don't know why these are so common as well, I'm sure developers know that what they are putting in kills pacing/fun, so why do they do it?

Fucking. Stop it!