Couldn't the raids conducted by the dragon be reconstructed by a skilled modder? So instead of enduring dragon attack couldn't you scripted bandit or sieges? Just a thought for the future...

not in theory, in fact. with greater flexibility to since its stated that Dragons just do as they please with whats availible in their AI packages and reactions to the world. same can be applied to roving bans of pwn face warriors. I intend to explore this significantly.

Maybe this is already implemented?

Yep, but I prefer dragons. Some argue dragons are too cliche, but I don't care.

Though dragons would be cooler, there could be something once you finish the main quest where the dragons are all gone, in which case it would be cool if other "raids" could happen.

I mean a modder could pretty much send an group of mercenaries/revolutionizers/plunderers to attack Dawnstar or Wintershold.

Hopefully this is already put in the game as a random encounter(s)

I'm just going to take on the wait and see aspect