I beat Twilight Princess a few months back and it was fantastic. I highly recommend it to anyone who has a Wii (and it is a reason to buy a Wii).
More recently I have been playing the Wii Prince of Persia game. After playing Zelda some of the controls feel akward, ports can do that. But it is great to play with the Wii remote.
On another note, I normally play on my PC desktops, but for fun I hooked up WoW on my MacBook Pro and set my Wii Remote to work with it. I then Moved around with the Wii remote for a little bit. Its a lot of fun, but there is no way anyone could play like that if they actually wanted to do more than move around a town.
For anyone curious to know about how long Twilight Princess takes, its about 35-50 hours depending upon how much excessive searching you do for all those little bonuses. My first completion was at 42 hours. I am sure I could destroy that if I played it again, but the puzzles just aren't as fun a second time. I wish the game were longer or that another Zelda game was going to come out soon. It was the best game I have played on any new system (Post SNES).
On other note, lots of people often times say WoW is the best game, for me its just the game that has held my interest the longest. But if Zelda had continued development like WoW does, I'm not sure I could ever stop playing it.