Unknown Armies is kind of like this. Most magic requires obsession, and you don't get a lot of well adjusted, friendly, people who also, say, collects all many of coin and money (money is power) but won't spend any (that's giving away your power!)
There's a bunch of schools of magic but they're all built on an obsession and paradox. The book is really well written, too. (At least 2e is. I didn't spend much time with 3e)