After claiming the throne of madness, a quest journal will pop up commenting on your advancement towards godhood. You will receive three lore-friendly spells as soon as you load your save file: Intangibility, Physical Form and Daedric Weakness. Consider this the ultimate endgame reward the devs never added upon finishing the SI expansion.
Since you came this far...
Have you played The Legend of Zelda, Ocarina of Time?
Remember Nintendo never melted Zora's domain after lake Hylia began refilling? That was actually cut content set to be implemented in the final version but the developers said they didn't have enough time until release. They never bothered to correct that in the 3DS version either.
That mod is as much needed for Zelda as this one was for Oblivion.
With proper dialogue lines and game reactivity.
I'm just pitching the idea.