Personally, Majora's Mask was my favorite, and it was a little too short, but it didn't ruin elda for me. It's STILL my favorite!
Twilight Princess was really hard, I didnt finish it (rented it from blockbuster), but I don't hate Zelda now.
Phantom Hourglass, it was ok, I finished it, it was fun, not the best, but it didn't ruin the Zelda franchise for me.
Maybe you don't wanna listen to me, cuz I've only been a fan since last year, when I got a magazine about it. That magazine changed my thought on those "stupid games": that's right, I'm talking about the Nintendo Power Legend of Zelda Collector's Special (I haz the Mario one, too!) Anyways, regardless of how long I've been a fan, I don't like most of the Zelda games I've played. But that doesn't mean Skyward Sword will ruin the Zelda series like it didn't with the rest of the games that weren't as good.
~Linkanon~