It's great. Some people don't like very much, but it's my 3rd favorite in the series (Ocarina of Time and A Link to the Past are my favorites).
And whatever you do stay away from the Cd-i Legend of Zelda games. Nintendo or Capcom were not involved with it at all, and instead Philips made the game. Philips was permitted to use the characters because of the liscensing agreement they had with Nintendo in the early 1990's, and I think Nintendo really wished they hadn't done that. Check out VGC's Link: Faces of Evil review to find out why these games were so wrong.