For just a solid combat system, hogwarts. Was really surprised. They had some solid people design and build it. Really stood out against the rest of the game which wasn't bad by any stretch just repetitive. There are some serious combat challenges too. Just make sure you play on hard. It really needed one difficulty higher tbh.

Magicka comes to mind but it was utterly unplayable single player. Maybe the sequel is better.

It feels very wizard like because you don't have a static list of spells. You have 8 elements you.can combine into spells. (It does have unlockable spells but those are sort of secondary.) So using the fire and shield elements makes a wall of flame, for example.

Heretic and Lichdom: Battlemage

Play Skyrim with ordinator mod that adds more spells.

Tbh, WoW is fun to wield magic in. There are many different styles and planning a rotation that is effective and effecient is fun.

Lots of good suggestions already, adding Magicmaker as a fun build-your-own-spells game: https://store.steampowered.com/app/319250/Magicmaker/

Theoretically, Immortals of Aveum could be good for this. It’s basically a shooter, but with spellcasting for the shots.