Check out the Gothic 1 Remake that dropped recently on Steam (I’ve been playing it nonstop since it came out last week). You can play as a fire mage with spells that range from a firebolt you can spam on the move to a three stage cast fireball capable of one shotting most enemies when fully charged to an honest to god Firenado! You can also shoot bolts of fiery lightning into the sky and make it rain fire.
This is a revival of an cult classic from 2001 that I never played back in the day but the new developers were super fans and absolutely did it justice, you can tell from the start that it was a passion project and it shows. It’s an RPG with a fantastic story that you can play through in 40-50 hours and well worth it in my opinion.
If you’ve been missing out of the fire mage fantasy in Midnight I would definitely give this one a shot!