Here are the best Magic users in the party in order...of stuff.

Crono
Marle
Lucca
Frog
Robo
Ayla
Magus

Magus has attack magic...thats all besides one spell which is pointless by the time you get him. He has no variety and no double techs. He just ing sucks.