Sorry for the confusion, I have no objection to Lightroom. In fact, I bought a stand-alone copy about a year ago when I saw a last remaining copy on a store shelf. I also used the cloud version when I started weddings until the team moved to something else.
I just want to know what else is available and if there is a best way to use Lightroom. Optimizing settings will have a learning curve and I'm good with that. If the end results are justified. It is too easy nowadays to spend time learning software only to find out it doesn't suite you.
If you ever use AutoCAD you see it is a very useful program, within it's limits. And I had the experience of needing one professor to remove some bad teaching from a previous one.
Thanks for clarifying, I think I see the question you're asking now. Let me toss out a few alternatives I've tried over the years. First a little background. I started with Lightroom 1.0, used every version up to and including 6.x, the last perpetual licensed version. I had/have a fundamental aversion to subscription software like the Adobe. It's not the monthly payment that irks me, it's the "what happens when I stop paying for it" question that I object to. If after, say, a year of payments I was able to cancel and stand pat on whatever the current version is at that time, well then I'd be perfectly fine with it. 6.x was fine when I only had a 7DII and 5DIV. Realizing I would one day get a new camera and LR 6.x won't ever support it, a few years ago I started looking for alternatives:
1. ON1 Photo Raw - I've used every version of this, they upgrade versions annually. I find this to be the most complete Lightroom alternative, but even 3-4 versions in, it's rough around the edges. Never did get the Lightroom migration to work after spending two months with their support team. It does ok with editing, keywording, and there is no import - you work with files directly in your operating system folder structure. Giving up on this officially now, each version has it's own bugs, it's getting slower and slower with each revision, and it doesn't do "cataloging" as well as Lightroom. And if I have to upgrade annually in hopes of finally getting a non-buggy fully functional application, aren't I on a subscription of sorts?
2. Adobe Bridge - can handle the imports and culling of photos, not really a DAM though. But the price is right (free).
3. Capture One - Pricey, high quality app but the DAM portion is lacking or non-existent (been a while on this one). Didn't last long with this one, just never caught on with it.
4. Luminar - Waited forever for their DAM, as far as I know it still hasn't materialized.
5. DXO PhotoLab - just started a trial a few weeks ago. Basically just a raw converter, but a powerful one that I may actually purchase. Like ON1, it works with files directly in the file system. Can do "Indexing" instead of cataloging, and also can use keywords, but I haven't used that part at all.
6. There have been others that I just can't remember any longer. Bottom line is, for me, no other application fully replaces Lightroom. Most do a little of what it does, none do it all. Not worth it for me to rely on 2 or 3 programs to do everything I can do in LR.
Where am I at today? I had budgeted for a new camera this year, planned on a 5DV, but going to get the R5 instead. Also just picked up an M6II, so my legacy version of LR would never support these camera's directly. Converting to DNG just wasn't going to happen, and I just utterly failed at finding a single application that would replace LR, so I choked it down and paid for a subscription.
I know...it still hurts just thinking about it. I was pleasantly surprised, though, that the current version is actually significantly faster on my 5 year old iMac. Maybe I'll get another year or two out of it. No more annual upgrades hoping ON1 would have fixed their app, at least this way I know going in what I'm paying and the app just works. What happens if I quit the subscription? I knew I could still browse and print my photos, but wasn't aware that you can still import new photos and use all the DAM functions. Only the develop and map modules don't work. Still not happy about that, but decided I could live with that if the subscription thing didn't work out down the road.
Lightroom is customizable, you can use it in any number of ways and find a flow that works for you. I generally use the heirarchical structure to my files, and "loosely" keyword things at import. This way I can find say, all photos taken at in May 2019 just by clicking through the folders, or I can also look for all pictures of eagles regardless of year or location by keyword search. File 'em any way you like, just one warning (and someone else alluded to it) if you use LR for managing file structure, don't ever move files/folders outside of LR.
-H