What I want is something where you can literally research magic, discover new effects, combine them to create new magic in form of spells, artifacts, rituals and so on. It should be easily accessible, after all it's a game, and not work. And have a bit of liberty in world interactions and movements. So maybe a easy metrovanian like Ori or Hollow knight, where you get new movements and open new paths through magic discoveries, but can decide your own difficult-level by either using some slow and safe magic in form of a ritual, or fast and dangerous by fighting directly with battle-orientated spells.
There are a bunch of games which go a bit in the direction, but are not complex and deep enough, like "Mages of Mystralia", or the Magicka-Games. Thinking about, a sandbox-environment might be the best for this, so Minecraft with some mods, or Noita would also go in the direction from a different angle.