Legend of Zelda games have classically been great. Link to the Past on the SNES was my favorite good balance of story, gameplay etc. I never cared too much for the CAPCOM versions of Zelda, i.e. Oracle(s), Minish Cap etc. but they're still pretty good. If you liked Ocarina of Time, you'll LOVE Twilight Princess, because the play is nearly identical with some nice Windwaker twists.
Personally, I'm also excited for the DS version: Phantom Hourglass
EDIT: Also, if you like Zelda, you might like THIS. A friend of mine does it, and he's like a Zelda fanatic.
"Tune In" to Newscast!