VIII has the worst magic system because it's tied directly into you stats and even with a high MAG stat, offensive magic does pathetic damage compared to melee. VI probably has the best magic system because it's overpowered enough to actually be useful unlike every other FF where eventually melee always proves to be the best offensive choice.