I don't really have much invested in the realms - I never cared for the over-the-topedness of the whole thing, nor the constant barrage of world-altering catastrophies. But it seems to me they could have accomplished what they wanted simply by advancing the timeline. The non-immortal, non-elf NPCs die off, wars happen, borders change, power groups fade away or are born, etc. So I don't quite understand the perceived need for the spellplague, which is lazy and sloppy writing. All the very popular areas of the setting survive intact for no reason other than their popularity, and the rest of the world is basically wiped clean. Now that's handy from a simplification viewpoint, but again, the passage of a century or two could have accomplished the same thing. Just not in such a over-the-top, world-altering fashion.
The stuff with the gods looks very tacked on to me. But then I wasn't aware that the FR gods actually did anything, outside of the Time of Troubles. Sure, that sort of thing is very common in real-world pantheons, but when have the FR (or Greyhawk, or...) gods ever acted like a real-world pantheons?