I guess my goal boils down to "give a bunch of normal people a little magic and some guns and make them fight (and interact) with horror/fantasy creatures" so I don't want them to be gods. Looking these recommendations over.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.