Sharepoint columns sync with File Explorer view, or an alternative option

Sharepoint is being advertised as the preferred data architecture solution for our organization. It is barely functional for what I do. The massive need is in part file versioning, original and added authors, dates created, latest date modified, EVEN File TYPE! - all of which are easily displayed in file explorer columns and simply not available in sharepoint, unless you open EACH file! Not acceptable. Sharepoint must have been designed by people who never manage multiple file edits, from multiple editors - most of whom are not in or can't access the intranet! Why didn't UI designers discover that people often need to compare 3, 5, 15 different file versions by just staring at the metadata columns? The File Explorer people figured it out!