I have yet to encounter any decent gods in RPGs. Or, at least, in DnD (but not many fantasy RPGs deviate in this respect). DnD never really settled down on what its gods are, perhaps out of desire to keep them as inoffensive and inactive, except when the plot demands them to be active, as possible. Are they just super tough guys who cultivated power a step beyond the normal level scale and get to be worshipped for the same in-setting reason the pagan gods did (when surrounded by vast and capricious powers, you need to appease them, and maybe, if you're lucky, buy their favor)? Are they worship parasites? Are they pillars of the universe and embodiments of concepts that keep it running? DnD gods were all of this. More often than not, at the same time. The game never committed enough to a definitive answer to actually explore it and weave it into the setting's past, mythology and current workings. 4E came the closest to writing gods decently, making them more involved with and integrated into the setting, while at the same time actually challengeable, but well, that approach did not last.