The Shivering Isles expansion has you work for Sheogorath in his Alice in Wonderland-esque environment.
Well, the American McGee version.
The ending of the game has Sheogorath pass his kingdom to you as he becomes another Daedric Prince.
(Being originally a cursed one).
Basically, it's the Gray Fox plot only you become a god instead of the GF.