I haven't played many, but the ones I have played have mostly been good. OoT is really overrated, but still OK. For me, the real star of the series is Majora's Mask: Better gameplay, really thick grim atmosphere, being the only 4D game I've ever heard of...
I played Wind Waker over at a friend's house, and it was pretty good. Better than OoT in my opinion. I haven't and don't plan to play TP (Seems a bit too generic for its own good). Skyward Sword just doesn't becon to me. Games that are just the developers telling themselves how awesome they are annoy the hell out of me, and that's the reason I didn't enjoy Sonic Generations. I played one of the Oracles games through, and it was pretty fun, but I didn't see much amazingness in there.
So, yeah, overall, I like the series. A reliably "Not bad" series, which I can turn to when I'm waiting for the next release I actually care about.