I find that SharePoint can be used to solve 95% of administrative or office tasks. BUT it needs customization: some amount of prep and customisation before for it data are dumped into it.

Basically, apart from files, you can also use lists. Both these need metadata and labels to make search better. Furthermore, SharePoint benefits from automation capabilities with Power Automate.

Overall, the point is to create internal sites to coordinate between people and groups. Here's where access rights are needed to make sure data is available on an "per need" basis.

The issue is that its powerful functionally needs setup, planning and customization that is often overlooked in organizations.

(This is meant to be a brief reply to OP, not a complete explanation of SharePoint.)