I have and used all of the spoken options (including Libre office, Open office etc.etc. etc.). There are many options, it really just depends on preference, usage and demands really.
I have checked out most options for others (over the years) also and this is an opinion:
For general usage: Pages, Numbers and Keynote is great. Keynote actually (as many will say) is generally better than Powerpoint, though of course Powerpoint over the years has improved and is constantly increasing its functionality to be a "go-to-app" now for presentations; especially when Universities (and generally Educational systems now) "train" students and almost demand them to use Microsoft Office. After the University years, they are use to Office, so they just continue to use it, including most jobs they go to after.
SoftMaker Office is decent...but has its limitations of course. The free version is adequate for most basic stuff and users.
For more complex applications, corporate synergy with the other apps in its suite and collaboration with others and teams etc. Microsoft Office is the best option for functionality and synergy....unfortunately.
Many Apple users (including myself) prefer the concepts and philosophy of Apples iWork suite (how it generally functions), but Microsoft Office is better for complex business and larger corporate activities now unfortunately. Maybe Apple (Jobs) made a deal with Microsoft (Gates) behind the scenes to limit iWork to prefer Office when Gates bailed out Apple with finances when Jobs came back to Apple in the late 90's when Apple was close to bankruptcy. That might have been the "deal"...
What kills (don't like) Microsoft Office for me (though I am force to use it because of collaboration with clients) is now you have to be constantly connected or logged in to Microsoft (365) to use. I would prefer the stand-alone option (use it too on some systems), but that can be costly and Microsoft purposely keeps the stand alone "as is" while constantly updating 365 (subscription) so sometimes new docs etc. have issues when opening up to the stand alone (in the name of innovation and security). Little glitches that eventually MAKE YOU purchase Office 365 subscription. Microsoft also knows to keep their subscription price reasonable and enticing if you are budget conscious. I also have issues with Office "calling home" all the time (meaning constantly connecting to Onecloud and their servers) and it has sometimes caused some issues with on older Macs (i.e. internet slow down etc.).
My preference.....(after using Microsoft Office since the beginning of its birth) Pages, Numbers and Keynotes. For Personal only (though Numbers is no way close to Excel in functionality). When Office first started the war WAY back when..WordPerfect and Lotus 1,2,3 was "it". Too bad Microsoft became king of the block. Corel owns WordPerfect now...but Corel has always had issues, especially after the original owner messed up business wise (probably grew to fast to handle) and WordPerfect is "just works" by title (once great) now only.
For collaboration, teams, business activities...Microsoft Office. It is the standard now..no way around it.