The main reason I am reluctant to use scripts (even though they make life easier 90% of the time), is that they are more fragile.
In the sense that if I change a field name, database name, or space name, that reference in the script will break.
So while scripts are more powerful than no-code automations, and with AI, even quite accessible, they are also more fragile. I have opted for complex no-code automations more often than simple script automations for this very reason.
Having the Space, Database, and Field names automatically update in scripts would have them match the fantastic behaviour of the current no-code automations.