I often think people suggesting things like Libreoffice just open csv files and scroll through then tell everyone else they can do everything in libreoffice.

When you’re a heavy user of excel, almost nothing else compares. Tho Google sheets does give excel a run for its money, because it has scripts (javascript) to do everything else.

LO Calc has python scripting. I think you mean power user, I can accept that LO calc is not up to speed for powerusers of Excel.

I'm a heavy user of LO calc, but my usage is of course different from yours. For true data wrangling I use R so this statement. I can't imagine the data wrangling and transformations that I perform in R being done in Excel. Its a nightmare waiting to happen!

Three out of those 4 things aren't functions. I do agree newer functions are missing (such as XLOOKUP) but for most people calc/excel is a high powered calculator and they use it as such. So Calc is perfect replacement. It's not the dark ages, that's an exaggeration.