I am absolutely beyond blown away with Columbia Records' presentation of this score! Five discs of music all looped twice and presented with pristine sound quality, and even better still, a booklet with detailed notes, including a reference list of which classic Zelda tunes are used and who was responsible for creating them. I have always found it baffling that Twilight Princess suffered from a subpar treatment from Symphony No. 5 -- no such detailed information and still a lot of missing tracks, not to mention abridgements of the boss battle themes. I made a much better soundtrack album myself. This is beyond amazing. It's one of the best presentations of any Nintendo soundtrack, period.
As for the score, sorry, can't agree with the complaints of it being boring at all. It's a much more subtle and restrained work, mostly quiet, with the occasional exciting bit. But I liked it a lot. This is a very beautiful work. I don't know where it ranks, but it's up there. Columbia's presentation just puts it over the top for me.
As for A Link to the Past, yes, that score is indeed amazing and iconic, but that's not to say the other Zelda scores are bad by comparison. They all have their share of great qualities.
Few will deny that Ocarina of Time was a significant turning point for the series, and being the first of its kind to introduce ambient tones for its dungeon pieces. Despite running on a dated sound system, Mr. Kondo's musical compositions are still iconic and very memorable, with the choral-driven "Temple of Time", "Gerudo Valley", "Hyrule Field Main Theme" and "Last Battle" emerging as stand-outs.
Majora's Mask's intentionally Chinese-flavored, darker-hued score may have seemed off-putting to fans expecting another Ocarina of Time or A Link to the Past, but it does offer some haunting pieces, like the "Giants' Theme" and of course the versatile "Majora's Theme". It's the wackiest and weirdest of the Zelda scores, but it's also great fun. Again, the sound system is problematic, but the songs remain appropriate and fitting.
I liked The WindWaker's Irish tones and its lively title theme, and the epic treatment of 'Hyrule Castle' on piano is a highlight, but I wouldn't consider it one of the best ones. Still, "Dragon Roost Island" remains a standout, as does the "Great Sea", and most of the soundtrack is done very well. The sound system is a bit better here than the N64 synthesis, although not quite as polished as the later ones.
Twilight Princess and Skyward Sword especially are both underrated. In spite of my gripes about Symphony No. 5's treatment of TP, I still am quite fond of the moody, melancholy tones of its score. "Midna's Theme" and 'Midna in Distress' are very haunting, and the overall vibe of the music works well for the game. I still lament the lack of a complete score of this album.
Skyward Sword absolutely needs a soundtrack album, no questions asked. In my opinion, this is one of the most underrated of the Zelda scores. Being the first to employ a full orchestra, it's all the more magnificent for it. "Ballad of the Goddess", "Skyloft", "The Sky", and the "Staff Credits" music are all terrific standouts, and there's a deep richness to the music that you don't necessarily get with a somewhat lacking sound system. Although there are some synthy tracks, they don't come off as lacking as their N64 counterparts. This is one of my favorite Zelda scores.
I will admit that A Link Between Worlds is also a worthy follow-up to those who want a true sequel score to A Link to the Past. Ryo Nagamatsu is definitely a name to look for. I don't remember that much of the music, but I do remember it to be very well done, and the sound quality is quite good for a 3DS soundtrack.
In short, I've never disliked a Zelda soundtrack, although it may be that I'm just not a purist about it like I've seen some people be. Of course for viewers demanding an ideal "greatest hits" compilation of the series, the Anniversary Concert album is a great choice, but I'm a genuine champion of seeing these music scores released properly, and I'm gratified to see one of them get the grand treatment, especially after so many years of being restricted to catalog only releases or limited issues.