I have the hypothesis that any programming tool geared towards non-programmers will need to be embedded as an extension for an app with a specific purpose (i.e. not a development environment). Users will understand better how to create an automated process if they can work on real data while writing the functions.
Avoiding the blank page effect is essential for such a tool, as non-developers wouldn't know what to put in a program if they start from scratch - they'll need some example data first, on which they can build abstractions that automatize steps for processing that data. Again, spreadsheets largely work this way.
Outliner apps would be a great use case for a programmable app for end users. We have seen examples of somewhat programmable outliners such as the Leo Editor, notion.so and the like; though they lack a good low-code/no-code approach.
Many developers know how to use Emacs outline mode for keeping track of their data and build automations over its hierarchical structure; a user-friendly, easy to learn tool that worked the same way would be a hit. It should made programming functions over the data tree as easy as functions on a spreadsheet, and that's the missing part from current tools.