I had the most fun casting magic in FFVI, but I don't think that was the 'greatest' magic system in any of the games. I really don't know what the greatest might be, but tactics can certainly give them all a run for their money.