Man, you are noting some wacky, very undwarf-like gods.
What about gods like Krishna? The dude was a goddamn general of an army before he became a god.
Anyways, I think it would be pretty awesome to unlease a new god, malevolent or not in the progress of the game. Maybe unearth some immortal supernatural trapped in the rock as punishment. I don't think EVERY god should be "unlocked" as you dig up adamantine deposits on a single world gen.
It works like that somewhat, the
demon you release from pits can tip the world back into the age of myth, because they are nearly god-like in their powers and influence
except it could be a different sort of god. I'm thinking of this fluff from Diablo that involved a beautiful angel flayed and mutilated in a chamber of mirrors so he could be forced to look on his horrific disfigurement for enternity.
Would be a nice for some deity like that to have a drunken naked midget crash through the wall and 30 lye makers barging in to the loot the place of the valuables in that angel's imprisonment. Something like that could even anger the other gods. THEN YOU KILL THOSE GODS WITH ADAMANTINE BALLISTAS AND MAGMA.
A sorta neat idea, but I don't think it should be a very common thing, the point of the game isn't to free obscure gods or battle mayrid sorts of sphere-related deities, its about killing things and making money from their bones and digging up rock and building impressive structures for your dwarves' glory.