Seeing SmallTalk, Hypercard, Visual Basic, RPG Maker 2000, etc, I was quite sure as a teenager that end-user programming would become ubiquitous within another ten years or so. It's surprising how little progress has been made.
Yes, I fear it's in some ways more difficult than ever due to the trends you describe. e.g. the architecture of SaaS software in particular makes it very difficult to work with data; kludges with Zapier and AirTable emerge as a natural result…