I always found the Ars Magica (Atlas Games) system of magic attractive.  Besides "learned spells" you could always improvise spells on the fly through their system of Techniques and Forms and risk fatigue and failure.

I never really understood why mastery/focus on certain areas of magic limited you to only certain effects, when you ought to be able to combine your abilities in creative ways (with risks, naturally).