I certainly didn't mean to sound over pejorative about the "non-programmer" spreadsheet authors. They're people trying to get stuff done using IT automation and that's a laudable goal to me. Sometimes their best intentions end up making nasty work for others later. Their hearts are in the right place.

I have mixed feeling about spreadsheet nightmares as a failure of the software industry. I don't think any amount of well-designed, technically better software is going to attract the particular stripe of people who see the ends w/o concern for the means. I feel like that kind of person is usually unwilling to learn anything that doesn't appear immediately in service of their goal (even if that learning would end up helping them in the future).

Short of AGI that to dictate their requirements to I don't think there's a technically better solution for some people. Even then, AGI would have to ask clarifying questions which, in my experience, this type of person regards as tiresome and needless. Trying to get these people to discuss corner cases, hard-and-fast business logic, and even basic workflow is painful.