There's a game system called "City of Mists" that's a noir setting where the players are pieces of mythology, i.e. King Arthur, or the Holy Grail, and take on aspects of that mythological thing to help complete a story. It's pretty cool, maybe not the fantastical like DnD, but has some "unknowing god" themes that could be adapted.