Jethro Tull are pretty close to what you're describing "all time great and awful"--the great was Stand Up, Aqualung and Thick As A Brick...and that's all that was for them that was great album-wise, the only decent albums they released after that were Too Old To Rock & Roll, Too Young To Die!, and Heavy Horses, and even those two aren't exactly albums I think about a lot.
The rest of 70s Tull was a scattering of occasional good tunes ("Elegy," "Cold Wind To Valhalla," maybe a few others here and there) placed on albums that were painfully overblown artistically (A Passion Play, Minstrel In The Gallery), painfully overproduced (War Child, slathered in way too many f***ing instruments), or which didn't live up to their conceits (Songs From The Wood, Stormwatch.)
I would not thoroughly trash A Passion Play as you have, but I listened to it quite a few times and all I really liked from it were "Overseer Overture," that part with all the colorful flying pretty keyboard noises, and (unsurprisingly) the parts that quoted Thick As A Brick. Oh, and I can at least remember the stupid bit about the hare. The rest of it I don't remember. Maybe someday I'll revisit it and be a little more coherent about it, but I've been trying that about every five or six years with Tales From Topographic Oceans too y'know? And to what avail?
And, then, of course, there's Tull from 1980 onwards, from which I could cull maybe 19 minutes of music that I'd be interested in relistening to, or which I could even remember in the first place, which are...."Fylingdale Flyer"? "Hot Mango Flush"? "Radio Free Moscow"? The band that did completely forgettable bloated dinosaur-band road apples like Rock Island and Catfish Rising?
Maybe Dream Theater and Weezer are a bit worse, but neither of those two bands has quite as long a discography (though perhaps we should just give DT some time, eh?) I mean, these are bands I have sort of a *history* with y'know?
Responses