I really liked Twilight Princess. It may not be my absolute favorite Zelda game (SS, OoT, and MM are better IMO), but for what it's worth it's still fantastic. And, more importantly to me, it has that element that the other three have as well but that the other Zelda games don't that just makes me want to play it over and over.
And, unlike a lot of people, I still like Zant even after he was exposed as a loony. I thought his helmet worked very well as a metaphor for concealing his true identity. He played the cool, collected, and intimidating villain the whole game, but really wasn't. And besides that, he's much more memorable to me because he flipped out at the end. Instead of a standard fight with a standard villain, it was a very weird fight with someone who's going bat**** insane.