It was a great game, no doubt about it, but for me it was a letdown. One of the things that make Zelda games so enjoyable for me is that it is about exploration. Twilight Princess was the first one however to consciously lock you down to a certain area until it was considered "completed". The twilight bug parts being the most blatant. In earlier titles, the only reason why you couldn't progress further was simply because you didn't have the right item yet. In here it was because some twilight shield held you back or that you got dropped into some sort of place without an exit before clearing it.
On top of that, in earlier titles you had some sort of freedom to choose in which order to tackle the dungeons. Wind Waker was an obvious example of that going downhill, but at least Alttp and oot both had points in where you had total freedom in choosing what to do. Which made the exploration all the more fun; it wasn't like I was held by the hand of a gamedesigner that was afraid "I might have lost my way otherwise". TP was quite the opposite in that regard. Then we have the boring fetchquests and the heart pieces that could be found easier than ever (though, truth to be told, I didn't expect them to be able to top the seacharts and the Nintendo Gallery from Wind Waker anyway).
It was a great game, no doubt about it, but I just can't think of it as a great "Zelda" game.