I’m sure everyone working in office 365 has this problem to some degree. My (pessimistic) guess is that Microsoft is aware of these problems and in stead of solving them in SharePoint itself, they create more programs to help organising. Like now you can find your files through Bing connected to your workspace (which is just to try and get people to use bing?). There is also delve and such that shows you what you last worked on regardless of its location. And soon we will have the AI co-pilot, which I’m expecting will make things even worse since it will grab anything you have access to and not bother with original context. I don’t know what the endgame is here, maybe make people and companies dependent on these kinds of programs?
Exactly! If it’s a small company, it may be an option to make a Teams everyone has access to and adapting the SharePoint behind it as the home page for the company, with different libraries depending on who needs access. At my company there is constant confusion between the SharePointsites the IT team set up for them and the SharePointsite behind their Teams, makes me think it is probably better to just use the SharePoint that’s forced on you by creating a Teams.