These thoughts are important. BASIC and HyperCard were both borderline miraculous in their way — limited, yes, still tricky, yes, but as an entry point, as an invitation? Magical.
My addition to this list: Smalltalk. The lessons of its aspirations and its limitations are as relevant as ever.
1/
what was end user programming like in the 1970s and 1980s?
for the average person, BASIC. by necessity, sometimes, because the software industry wasn't yet distributing as widely, and physical copies were harder to produce, etc.