The actual problem here isn’t cloud, but the fact that Microsoft Office’s ‘save’ UI/UX is such a shitshow, it’s completely unintuitive as to where a document is being saved. We have a massive problem with this at work, because people frequently accidentally save stuff to OneDrive, rather than on their local PCs, and then completely lose the document.
If you haven’t looked already, my app Damselfly might work. It uses the existing folder structure, displays all files (duplicates or otherwise) and has metadata editing and updating.
You can run it alongside other apps, so you could use Damselfly and Photoprism, for example, and get the best of both.
Album support is not really there, but it focuses on folders mainly (because that’s my use case). I have it running on a Synology, with a 5tb collection of 670k photos, and it’s fast.
None, because I’m a developer of a self-hosted project. So I figure I contribute enough…😁