NixOS is the best operating system I absolutely cannot recommend to anyone - Anurag Singh
(www.xda-developers.com)
I think what you're looking for is simply an indexer + UI that sorts your filesystem by tags rather than by directory structure. Not sure if that's as beneficial as you imagine it to be, but IIRC KDE allows you to do something like that in Dolphin.