Mostly used Cure when playing as Roxas. When I played in multiplayer, I used fire for Axel, ice for Vexen/Demyx, air for Xaldin, etc....
I was kinda disappointed by the magic turnout. I was hoping there might be some offensive "light" magic, but the closest magic we get to light is cure....