I've had nothing but negative experiences with Microsoft and their products on macOS. Unsurprisingly, dealing with their "support engineers" is maybe even more frustrating than using a macOS device that is infected with their software.
Speaking as an experienced person when dealing with M365 products in our fleet, I absolutely, 100%, cannot, in good conscience recommend for any company that supports macOS devices to purchase or use any Microsoft products. There is simply no amount of money you can pay (I'm fairly certain we have one of the highest license tiers) in order to get any assurance that you will get any meaningful functionality or support from them.