Death Sorceries in Eden Ring.

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.

Wistram from The Wandering Inn. With all the secrets, drama, bureaucracy, and faction infighting it feels like a real school.

That being said, no way would I attend that place. I'm going to stay the hell away from that place and watch with popcorn at a distance.

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.