Even now it's mostly useful as a teams backend. But even that doesn't solve the shitheap problem, as any team you create in teams, or every yammer group automatically creates sharepoint sites which are not very useful as a sharepoint site and clutter up search results.

Users often don't understand that when they share something in teams there is an actual sharepoint behind it and sometimes people fiddle with permissions there and then other people don't understand why they're not allowed to do X or Y because the controls aren't fully exposed in the Teams interface. It's such a mess.