I am still waiting for a RPG game where there is a set magic script and you can create your own spells like programming.

That's a cool idea. I like games that have mechanics that teach kids programming without them noticing. Stuff like FF XII, Unicorn Overlord, or Factorio. There are also some that are more "on the nose" like Human Resource Machine, but for my taste they are too far on the teaching side and not enough on the fun side.

As for magic script, the Ultima series had an actual magic script from which you assembled your spells. It's not very complex and didn't exactly reminds one of programming, but I wonder where it could have gone if the series didn't die with such a framework.