I was born in 1991, so there is not much I can say about that period from my own experience.
In the mid to late 90s, my father subscribed to some Mac magazines, which often had a supplemental CD-ROM. It contained a lot of software, including HyperCard stacks, submitted by readers of the magazine. I remember playing with them a lot.