I am not afraid to tell you, with my list of attributes it was not easy finding the right software package that fit them all. However software development companies have strategy sessions and customer feed back venues for just this purpose to develop their software to be the most applicable and versatile tool for the user available on the market. So do not be afraid to make a list of your desired software attributes.
Finding the software specifics:
Lightroom: Yes, to all but editing, and a drawback for investment. However, investment is not a bad thing, because it gives some assurance to customer support and software development.
Darktable: Yes, to all but editing. GPL and free downloadable installation. Good for starting, but how versatile is it really being free?
Aperture: Yes to all but editing and sharing to personal web albums. Is paying less than half for Aperture worth lacking the workflow to web sales? Not for me as workflow is very important.
Finding software to fit your situational requirements is research intensive, ending with all hope in an ideal solution. The start of the research period is difficult because no description of the program is the same as I search it. So the best form of research is to take the tact of searching “similar program to” the program with which you are familiar.
I have used and was familiar with Adobe Lightroom, so searching for similar programs was not easy to find, but I was familiar with the aspects of the program I sought. If my research ended with no other results, my opportunity to invest into Adobe Lightroom was a primary option for business workflow. Having found Darktable by interest from a recommendation I search it through the developer’s website “darktable.org” and found it very informative.
It is also beneficial to make informative contacts within your market description in or outside your market area. This is how I found out about the Mac software “Aperture”. Using resources for information and helping them by giving useful information is a great support in business and among hobbyists.
Service is important whether payment is rendered or with “gratis” consider its worth in relationship gained more than capital. Business is built and is maintained on relationship not spontaneously occurring capital gain.