Google is your best friend!! I know of some snes DBZ games I played in the past. Some fighting, Some rpg style. Gameboy advanced I believe had some american DBZ games. As far as spyro, Google how to get a ps1 emulator working.
i have played dbz mugen2007 (pc game) 500mb, and it is good, i have played some emulator games too but they are not that goo like that of mugen of pc, and i haven't played any console games.
i my opinion mugen is good in dbz, you can do many special beams and transformations too, but it is for pc (don't know if available for consoles and emulator
------------------------------khuda ko dikh raha hoga,
na dil tujhse judaa hoga
teri taqdir mein mujhko,
woh ab to likh raha hoga Reply to truegenius