I always found the idea of a diety who has, through their own machinations or power, caused themselves to be in an adverse situation. A god trapped on the mortal plane due to some failure in his/her schemes. Think of the Stone God (Uhl Belk) and his "Child" from Eldwist in The Druid of Shannara by Terry Brooks. I found this part of that saga to be truly captivating.