I like FFVIII and FFX's magic systems. In FFVIII you can Junction magic to stats however you want. You can draw very powerful magic early on in the game. FFX's Sphere Grid allows any character in the party to learn any spell on the grid, so that all characters can cast magic not just one or two characters.