A bit of a cliché one but still the Water Temple from Ocarina of Time. My first time playing it I got completely stuck there and didn't go back to the game in about a year.

Whenever I play it again I always remember to pull that damn block out near the start.