It might be the case that a better language for this sort of thing would have to be designed. Maybe somebody needs to take another crack at the sort of Visual Basic/Excel type environment.

I think someone on this site chimes in occasionally with a sort of “spreadsheet, but each cell runs a line of Python” type program they’ve been working on (although I can’t remember the name unfortunately). That could be a good basis…