Lightroom totally dominates the realm of digital asset management (DAM) a solution for everything, it fits the mold of most photographic workflows, however the bitter pill to swallow can be the treacle-like performance and that monthly subscription. Is it time for Adobe to start again?
Digital asset management is something we all do as photographers whether its as simple as copying image JPEGs straight off your SD card and dumping them in to a Pictures folder, or ingesting the raw files pre-tagged into date named folders that are cloud synced for anywhere access. The care you take will depend upon what you want to achieve and who you are delivering the images to.