For gods that work as player characters (are powerful, but not immortal) look to Forgotten Realms for ideas. Mystra died and was replaced by a mortal. A few other gods died during the Time of Troubles, some at mortal hands. I don't know if any of the gaming material goes too far into it, but there are several novels that do just that.
