I haven't bothered with the Spellplague business. I'm actually a huge fan of the 4th Edition D&D (mostly because it made my life so much easier as a DM) but I did a cursory thumbing through of the Forgotten Realms campaign book and found little interesting. Of course, I've never been a fan of published settings for games anyway (with the exception of Planescape back in the 2nd Edition days mostly because there was tons of room for the DM's own world-building desires), so I just assumed it was an extension of that.
And the Drizzt books were the only FR books I read, so I don't know too terribly much else about it. I got about as far "A Thousand Orcs" before I just put the book down mid-read and never went back to it. I ran into the same issue with the Dragonlance books too. After the Legends Trilogy it just didn't hold my interest.
I actually enjoyed The Hunter's Blades trilogy a lot. After the spellplague, though, things got pretty bad. Really all of Transitions was kind of rough. I pretty much agree with you about the Dragonlance novels though, they lost my interest after a while. Still, the original Chronicles were great and I'll read almost anything about the original characters from that trilogy.