Spreadsheets are rather peculiar. I don't think anyone would come up with the concept of them today.
This "fill formula down/right" feature is so strange. A developer would be like: let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something. Like Airtable.
But its surpringly flexible and hackable.
I wish there was something like GSheets + Airtable.
Sounds like you're describing Grist! And it's open source. https://github.com/gristlabs/grist-core