What are your favorite games with unique and fun magic systems?

The spellmaking in oblivion was pretty great too, you could make multiple spells which applied weakness to magic and to specific elements in enemies, and since they were applied by different spells they would multiply each others' effects. Then you hit the enemy with a damaging spell and annihilate them.

I never saw it mentioned anywhere, but for me, hiring enemies with sufficiently powerful magic would ragdoll them, a bit like if you hit a corpse or a paralyzed enemy. So doing a 4-3-2-1 combo, 3 different spells that applied 100%weakness to magic and lightning, then hitting them with a lightning spell, would always send them flying. Sometimes it would be like they just vanished because the amount of damage applied by the spell threw them so forcefully.

Tyranny had a fun system where you could create custom spells based around combining a Core Sigil with Expression, Accent, and Enhancement Sigils to modify the spell's behavior. So you could have a Fire core sigil, combined with an AoE expression, fast cooldown accent, and a bleed enhancement. Of course the spells have a cost attached to them so you couldn't have your mages casting ridiculously powerful spells on rotation until you ran out of magic, but you could pop it off once or twice then fall back on weaker, faster spells. Unfortunately like with most flexible magic systems like this, mage characters are overpowered as hell, as long as you have your party tank camping a chokepoint.