Pivot Tables was the last big feature completely missing, which is now available. Numbers might meet most of the spreadsheet requirements, except some scripting requirements. There is Applescript for those who are inclined that way. For my own use cases, I use LibreOffice Calc, even on macos. I started using it an year ago, just to see if it can work at all. So far, I haven't had any blockers, but my usage is probably not so complex.