The puzzles that come to mind when I think of hard in Zelda would be:
Ocarina of Time:
The puzzle in the Ice Cavern, the one when you need to slide the blocks in order to make the path for your self and collect the silver rupees. That one took me a while, at first it seemed pretty obvous but...