Don't mix up poop and chocolate - while Google's accounts aren't really that great (the whole GSuite mish-mash of nonsense doesn't really help), they are several orders of magnitude better than whatever MS is trying to do here. You have a million different ways to permanently screw yourself with a MS account, especially since they basically kept all the "account types" hidden while applying over them a veneer of homogeneity. You can basically use any Google account everywhere a Google account is required, but personal and corporate MS accounts are basically two different things that reuse some infrastructure while not being compatible the slightest. Even when logging in in Windows, there are a dozen ways to enroll a MS account, and most if not all of them are not compatible with each other. There's always a very high chance of getting your Windows account messed up, not accessible, or impossible to log in to.
> You can basically use any Google account everywhere a Google account is required
This is not true if it is a Google Workspace (or whatever they are calling it now) account. Learned this the hard way when getting YouTubeTV. To be fair, it was just a couple of hours of frustration and annoyance but still, for whatever reason, the workspace accounts that you pay for are second class citizens.
I had to abandon my Google workspace account with my main email domain after they booted the free GSuite status (I migrated before they changed their mind unfortunately). Not only is that account gimped because it is a Google Workspace account (with little things all over that refuse to work with those style accounts at all) now it's even more gimped because it has no active subscription tied to it.
I can't downgrade it to a personal account without deleting the account and recreating it, but there's not even a guarantee that will work. Deleting the account will also mess up family photo albums and other items. Photo storage is full but I'm also unable to pay for storage without adding a subscription to the account. It's so risky to try and fix it that I just had to migrate to a new google account, re-purchase all my android apps, and just ignore that account forever.
A Google Workspace account does not work for Nest. I signed up for the free Google-email-but-with-your-domain thing more than a decade ago. A bit more recently but back when I was still a Google fanboy I bought a Nest thermostat and was astonished that my account could not be used for Nest.