You give two examples (spreadsheets, Autohotkey) that actually contradict your central thesis of no good tools. Seems like those are examples of ordinary people successfully using no-code to make their lives easier?
There are so many free programming languages available to anyone interested, ranging in human comprehensibility from (the incomprehensible) brainfuck [0] to natural language interpreters for writers of interactive fiction [1], and everything in between. Visual programming languages [2], languages for children [3], languages for visual artists, for musicians, for stock traders. There's even a language using power ballad lyrics [4]!
I love your sentiment that programming is for everyone, but with respect I utterly disagree that there are no good tools for ordinary people to use. If anything, there is an overwhelming, embarrassment of riches.
But, maybe you are right? Maybe you have an insight that could be helpful? Share it, man! The world needs you!
> ...we kneecap them with awful tools
Who is this "we", Kemosabe?
If you want to help make interactive narratives easier and less prone to bugs, I have a fallow side project I need help with [5]. These people seem cool [6] and could use your insights, I'm sure (seem to be defunct, but perhaps from lack of interest? Jump start it? Track them down, find out what happened?)
[0]
https://en.wikipedia.org/wiki/Brainfuck
[1] http://inform7.com/
[2] https://en.wikipedia.org/wiki/Visual_programming_language#Li...
[3] https://en.wikipedia.org/wiki/List_of_educational_programmin...
[4] https://codewithrockstar.com/
[5] https://github.com/rendall/quest-driven-development#readme
[6] http://blog.interfacevision.com/