Ocarina of Time and Wind Waker were absolutely killer games, although the former has aged too much to be enjoyable IMO. Wind Waker still stands strong though, its near-perfect visuals only marred by a low resolution. I didn't like Twilight Princess so much.
If nothing else you should play HP for the art, HP! It was a masterclass in getting beautiful visuals out of relatively simple ingredients. To me it looks like they literally hand-painted every texture for every situation, as everything lines up freakishly well and with a true artist's eye.