Well, there's Mage: the Ascension from the old World of Darkness. It's modern-day, after a fashion. Mages can do really amazing things, but most of the time it's not flashy; the consensual reality doesn't like that, and they want to stay hidden.
The magic system is all kinds of powerful and...