Crazy how different people experience this.
For me it’s completely inverted; Google is top place, then Libreoffice, then MSOffice, then anything by Apple last place.
I value performance and stability highly, and Apple's productivity programs are so light I can leave them open in the background and forget they're running for months at a time even on fairly old, weak machines. And I'm not sure I've ever seen any of them crash (I can't say the same about, say, LibreOffice or pretty much any other Linux-associated productivity software). That they're a ton more polished and stable than things like Abiword or Gnumeric, and have most modern features I'd expect (even live collaborative editing) puts them solidly above those other light options.
I hate modern MSOffice's UI, plus it's full of slow, heavy webtech which deducts a lot of points from basically anything for me. Google's leaks memory (like most of their software... so do Gmail tabs) and is so slow that it introduces a ton of input latency, which drives me nuts, I hate to type in it, aside from my experience with most of its formatting and editing features being that they're very janky even by the standards of GUI word processors. Both are very heavy on resources, which means they have a huge hurdle to overcome on the feature side before I'd consider them anything but extremely-unpleasant.
Old (like... '00s) MSOffice is pretty good because it's not such a resource hog, and the UI used to be really good.
I do like Keynote (their PowerPoint alternative) but I do agree that everything else is absolute garbage. But I guess someone has to like it.
That's my exact ranking as well.
Yeah that would by my ranking too. At work is Google because it's the best, particularly for collabotation, personally all in on FOSS.