I'll admit Phantom Hourglass is the only Zelda I've played in like 20 years, that I started, and did not care to finish at all. So I haven't even given Spirit Tracks a chance, but I hear it's better. Might try it someday. Minish Cap was super average though, I beat that one and... bleh. Can barely remember anything.
Personally had no problems with Twilight Princess myself, despite most. I really enjoyed it even though it didn't bring a whole lot of new stuff to the table, oh well. It felt a bit more like OoT/MM than WW did, so that was cool with me. The Dark World idea sucked though, but luckily it wasn't utilized that much after awhile.
My only real big gripe with WW personally was that it was probably by far, the easiest Zelda game to me. The dungeons were a joke usually, and just the entire game was not that hard at all. So yeah... I guess that bothered me. I was a little underwhelmed in the same way with Metroid Prime 3 (felt like they threw 90% of the energy tanks at your face!), but it was still a really fun game, just not my favorite of the trilogy.
So WW is decent in my book, but nowhere near my favorite Zelda. I don't really see it as the harbinger of doom against the franchise, though... I buy systems for Zelda games, so maybe I'm a fanboy outside of the handheld titles.

