This thread has come at just the right time for me. I've got a 500k/3TB photo collection, and have been looking for a DAM solution for ages. I'm now at the point where I've started writing my own to run as a web-based server app to run on my NAS, so I can realistically search all of those images by keyword to find specific images.
The workflow is:
- Import photos into local app X
- IPTC tag images in app X
- Run sync to push images to the server
- My DAM app (working name 'Damselfly') will index the images and metadata into a DB, and provide full free-text search by name, IPTC keyword, date, size, lens, camera etc, etc.
- DAM app has a 'basket' concept where you select a bunch of images, into the basket, and can export them to your local computer to work on them in app X, or alternatively export them to Wordpress, Facebook, email, etc.
- Once you've finished working on them locally, you re-sync them to the server, which re-indexes them.
Previously, 'app X' (used for local keyword tagging) was Picasa, and/or LR 6.14. I loved the simple workflow, and it worked really well. But my Mac keyboard finally died and I needed to upgrade, and my new Mac has come with Catalina, which means no more 32-bit apps, so no more Picasa or Lightroom. I'm also not interested in signing up to a subscription model for Lightroom.
So I'm going through the same hair-pulling exercise right now. I've installed most of the apps on your shortlist (possibly, more, can't remember). My problem is that the with all the apps I've tried, the workflow/UI/UX for keyword-tagging large batches of images can't match up to the simplicity of Picasa. My current shortlist is:
Everything else is either too slow, too clunky, dangerous to my photos (ACDSee's destructive non-destructive image editing is going nowhere near my library, for example). But even those two have their annoyances.
My DAM server-based app is making good progress, and will hopefully be in a state i can release it more widely in a couple of months. But I'd appreciate any recommendations for the app X in #1 and #2 that has the best tagging workflow....