I am not quite the right age for hypercard as well, but I did have my chances to interact with a variety of game making tools aimed at kids that were amazing for creating event-driven logic. Likewise in the professional world, tools aimed at business professionals (like MS Access), that kinda were abandoned - and there used to be a whole spectrum of stuff that connected WYSIWIG editors and simple languages to various levels of programming tools.
The demand for this was huge.