Macros are one reason for me as well. LibreOffice actually supports VBA! But only a subset, so YMMV.
If it’s for work then probably also best to avoid converting back and forth between Word and LibreOffice as well.
I’ve been pretty happy with Linux though. I’m currently running the Gnome version of Nobara but have been through a few distros to get here. I ended up keeping my files on a separate partition to make it easy to install a new OS so I could test out a bunch.
None were perfect but I’m pretty happy with what I have now.