>>96797290 (OP)
No but in all seriousness, at least "what's the coolest" is a question that makes sense, so I will answer here.
There's two games that really makes magic like... well... magic.
>Unknown Armies
Magic users have an obsession through which they act supernaturally over reality.
So they gather magical charges by indulging in these obsessions and pushing them to new limits. And the type of effects they can get depends on their obsessions. AND these powers comes with taboos, which also make you vulnerable in different ways, related to your obsession.
For example, a bibliomancer (obsessed with books) can obtain magical charges by buying rare books, will lose all of his charges if he loses or sells one of his book if he doesn't have another, better, edition of it. And his spells influences the knowledge the general population have of things (IIRC).
The game is urban fantasy, so the obsessions available are stuff like: tourism, self-mutilation, porn, drugs, TV series...
>Scales
Much more obscure French game, also urban fantasy.
Draconic magic is all about channeling spells through an art form (which can be very varied, from architecture, to tattoo or even cooking). The types of spells depend on which art form the magic practitioner is familiar with:
With architecture or gardening, you can set magical traps. With tattoos, you can give magical buffs to you or someone else. With poetry or dance, you can cast offensive spells.