That was the entire appeal of Notes/Hypercard, people could throw together a small database application and it wasn't any more difficult than creating a spreadsheet. (The big difference was that Notes apps were automatically network client-server.) I think it's rather cynical and elitist to say that something which empowered users "destroyed IT capabilities", and it's not like many of those small orgs really had IT capabilities.

But like HC, the Notes designer software was turned into an added-cost product, and after that both Notes and HC became the domain of 'IT experts' that knew how to work around the limitations of a rinky-dink platform.

This was all long ago, for most people now Notes is just a terrible email application.