I enjoyed the magic system in Patrick Rothfuss' books. It felt relatively believable/grounded, and I liked the concept of learning the "true name" of things.
His ideas on magic were awesome. I liked the binding system as well. I recently read R. F. Kuang’s book Babel. She has a different take on “binding” using similarities of meanings and multiple meanings of words from different languages. It was a very neat book, though it was reminiscent of the magic in the realm of Temerant. I recommend it.
I find it pretty funny how they convey the fact that "death is scary" by making most of the Death spells in the game something you wanna run away from, even though it probably won't actually hurt you because they are kinda weak, but nobody is gonna just stand there while a ton of floating, flaming skulls are flying slowly at them.
Second with regular Glintstone sorceries from the Raya Lucaria Academy. They literally put all their intellect into what amounts to "throwing bigger rocks" and thought the one sorcerer who found it prudent to make something more defensive to be the biggest idiot in the school.
This one is from a technically scifi series, but the early books read like fantasy and there's dragons and stuff.
The Harper Hall, from Anne McCaffreys Dragonriders of Pern.
It's a music school... but music is pretty magical. It also set my expectations for all magical school books that came after, even if it's technically scifi.