AbdulAlhazred
Legend
I can see lots of cool stories about why gods need worshipers for power or even to survive, but I agree with the OP that this can detract from the wonder and awe one might feel towards them.
To me the reason gods recruit mortals is that worshipers allow a god to spread its ideal reality to wherever its followers are as well as draw strength from that area. So a god of winter like Skadi can start pushing the world into her ideal version of winter as well as draw power from the winters of the worlds her followers are on.
So worshipers are a resource, but there isn't an exact ratio where 10 worshipers equals 20 spell points or anything. Some of the more mysterious or hostile gods might eschew large congregations in favor of spreading their portfolios. So a plague god might spread plagues across the Prime using jackalwere cultists because every person with one of its diseases is a power source. A god of conspiracies and anarchy might only have a hundred followers, but the god sky rockets in power when the 7 kingdoms go to war.
Really, I think the mystery of why gods recruit mortals helps keep the game's sense of wonder alive. Also, personally I don't like stats for gods but that's just me.
Yeah, overall I eschew hard and fast rules. After using the same basic homebrew setting since the early 80's I still haven't settled on any exact 'rules'. It is enough that the PCs can effect the history of the world when it is interesting to do that, and the gods are mysterious forces that mortals don't really understand. Even if now and then one of them becomes powerful enough to claim to be a god (and maybe is, who knows).