I like Terry Pratchett’s witches and their magic. I like the Tiffany Aching books in particular and the type of witch that she is. I like how a lot of their magic is mundane based, but that they do also have power.
I don’t like his wizards very much though.
For roleplaying, I like the magic in Mage the Ascension the best. I loved the freedom, the paradigms you had in which it was through your own beliefs and view of the world you could change things.
I liked in Robert Asprin’s Myth books, how the main character just had a couple of extremely simple spells, and a whole lot of bluff. That he was eventually considered a powerful wizard, even though he would have been a beginner in any other world. I think he had one illusion spell, he could levitate items, and he could light a fire.
I think I like magic users who don’t always use their magic, apart from when they need to. Ones who aren’t the almighty, all powerful chosen one.