>game takes place in a medieval world with magic, dragons and shit
Toriyama designed DBZ to end with frieza, and goku becoming the SSJ of legend from the grounds-up, then greed overcame him and he desperately extended it to shit.
Everyone knows this fact.
SMT Strange journey has a gun that you can get relatively early on in the game that lets you cast powerful magic.
And then there's Sahz in FF13, but he's bad combat wise