Here’s a survey I authored ten years ago that conveys the gaps and a decade of innovations on addressing them:

Amy J. Ko, Robin Abraham, Laura Beckwith, Alan Blackwell, Margaret M. Burnett, Martin Erwig, Chris Scaffidi, Joseph Lawrance, Henry Lieberman, Brad A. Myers, Mary Beth Rosson, Gregg Rothermel, Mary Shaw, Susan Wiedenbeck (2011). The State of the Art in End-User Software Engineering. ACM Computing Surveys, 43(3), Article 21, 44 pages. https://faculty.washington.edu/ajko/papers/Ko2011EndUserSoftwareEngineering.pdf