Why "God Mode" Is Bad For Stories

So: "Supernatural". Apparently, angels and demons are finally at war, with Earth - and the Winchester boys - right in the middle of the conflict.

Now, here's the snafu, and the very real reason why it's rarely a good idea to confirm the existence of God (much less the biblical God) in a fictional narrative that runs the way "Supernatural" does: according to Dean's guardian angel, God gave the order to spring the elder Winchester out of Hell, because He's siding with Heaven and humanity against Lilith and her demons (and, presumably, Lucifer).

Someone please explain to me where I'd find dramatic tension in a situation where God, Creator of the Universe is backing the hero's team. I mean, the show basically says God is actively working to thwart Lilith - "Why'd you do it?" "Because God commanded it. Because we have work for you." And... I just have to stress this. God. Tilts the odds just a bit in Heaven's favor, no? It's not being played like a deity idly watching Ragnarok approach, and apparently we're dealing with New Testament God here, as opposed to "Joan of Arcadia" God who doled out tasks and hints but wouldn't (or couldn't) directly intervene.

So are we supposed to think that Lucifer has a chance of beating God and the Home Team? Uh... whatever? I don't know. It's a weird, weird plot angle and I'm still not comfortable with it.