I, in general, would like to see the downsides of being god (as in living forever, people being dependent of you).
As for examples, how about a forgotten god, that is, for one reason or another, left out of the pantheon and is worshipped by no one? This said god would then try to find a way to make people know and worship him/her. Perhaps s/he can't directly approach humans (other gods wouldn't like it if someone tries to "steal" their worshippers) and disguises him/herself as a mortal prophet (quest, maybe)?
Or a childish god who uses his/her powers only to pull mischievous pranks on mortals. S/he wouldn't nesessarely be evil though, just enjoys a good laugh.