OP here. This is my workflow, it doesn't have to fit everybody else. If you want a single software to do everything then you should give Darktable [0] a try, i

OP here. This is my workflow, it doesn't have to fit everybody else. If you want a single software to do everything then you should give Darktable [0] a try, it can handle all steps in my proposed workflow including importing, browsing, editing and metadata organization. It even exports to third-party services. I think it has more features than Lightroom, although the UX is arguably worse.