While there are some frustrating parts I’ve found that it gets the job done reasonably well and integrates well across the products. I’m a power user so I can often find workarounds for even the things that bother me. Teams communicates well, sharepoint stores the files for my group just fine, office does what it always does, then I get these other useful tools for forms, databases, video sharing, etc.
I think the biggest problem for most people is that they never received adequate training. I trained myself so I skipped that limitation.