should really have been databases

It’d help if the database options weren’t piles of shit: they’re all so particular about data types and column definitions. And then the data entry tools (“forms”) are always a mix of shit UI and insane programming.

Googles “tables” within sheets get reasonably close to what a system like that should look like.