Two worlds series is famous for this. Spellmaking is one of the few redeeming qualities the game have and its great There also dragon dogma. Its not super creative or anything but really satisfyimg to cast. There a game called Lichdom battlemage which have a customisable spell you can create.