For me biggest missing I’ve found is web/external queries. Excel has a system to log in to an API, retrieve that data and format it before it lands on your sheet.

Libre functionality here is lacking/non existent.

My workaround was to write a python query, add it as a cron job, write that data to a csv then call that csv from my sheet with a timed refresh. Not something the average user can or wants to do.

Everything else I’ve found achievable.