In regards to spells, there are literally tonnes of out-of-combat utility spells, so it depends very much what role you see yourself fulfilling. You mention that you want be a support kind of mage, but what kind of support?
I'll mention a few examples.
Detection spells : clairvoyance, detect life, detect enemies, mind probe, mindnet. ....etc.
Health spells : heal, increase reflexes, increase attribute ( body or agility probably )......etc.
Illusion spells: improved invisibility, physical mask, chaff/ decoy, chaos, Trid phantasm, .....etc.
Manipulation spells : armor, levitate, Influence, control thoughts, fix, [element] wall, mana/physical barrier. ....etc.
In any case it's a good idea to actually decide before you start picking spells what you actually want to acomplish with your magic.
Also, getting a mentor spirit that provides bonus to whatever type of magic you end up focusing on might be a good idea.