that reminds me i hated the underwater section in metal gear solid 2! took me forever the first time back on the ps2. it's easy now because i know the whole game off by heart but at the time ARGGGGHHHH!!! 

Another was medal of honor frontline. quite a bit into the game there was a level where you had to get through a shit load of enemies in the middle of the city and i could never do it. and if you died you had to restart the whole thing. i actually never completed that game and me and my cousin tried so much. 

The mini remote control helicopter mission in one of the GTA's on PS2. That was so hard to do especially when you're young and not that good at games.

Most definitely the water temple in Ocarina of Time.

See, I would say Anor Londo. I've cleared both the Catacombs and the Tomb of the Giants several times, and I die a lot every time, but I've never felt like the game was cheesing me. The two archers covering the spire in Anor Londo, though....

Dark Souls usually stuck to the "hard but fair," mantra. Usually.

Long caves and Victory Road in every Pokemon game. I don't like using repel until after I beat the Elite Four so the random encounters get annoying fast. Meteor Falls is okay though because of its awesome music.

That is the most unfair portion of the game, but it's not too bad if you have the rings that make you semi-invisible and the one that makes your movements silent (though the former can be difficult to come by) which allows you to set up with you to engage them one at a time with a bow, though I don't think you can get a heavy bow until anor londo itself so that makes it a bit more difficult on your first go around.  But aside from that part anor londo is one of the best areas in the game I think.

Worst section to me is blighttown, with all the poison darts, narrow scaffolding and horrendous framerate issues just makes that area a headache.

The problem with that is that it's levels like this that make a game irredeemably bad so there is no love to give it.

As far as contributing, stealth levels in Zelda games.

Funny thing is, I never actually had troubles with the archers in Arnor Londo, I was actually quite a bit suprised about what the fuss was about. I suppose in a game like this opinions will quite differ and definitely I've had trouble with areas that people had no issue with.