I use and love DigiKam[0] for organizing my ≈230k RAW & JPG media library, and both RawTherapee[1] and Darktable[2] are great for more specific editing (though I haven't settled on an ideal workflow yet). One cool thing about DigiKam is that you can have it use a remote MySQL server for its db, theoretically allowing you to work with your library from the road (I think... it's been several months since I've spent a weekend working on my photo libraries).
Adobe's Lightroom truly is a great and powerful tool like so many of their other apps, but I just can't stomach having years' worth of work locked up in a proprietary subscription-model app. And I just consider Apple Photos untrustworthy, though I do like to use it + iCloud shared photo albums to publish my edited "selects" instead of my full library.
Now if only there was a real F/LOSS contender to replace FCPX...
Adobe's Lightroom truly is a great and powerful tool like so many of their other apps, but I just can't stomach having years' worth of work locked up in a proprietary subscription-model app. And I just consider Apple Photos untrustworthy, though I do like to use it + iCloud shared photo albums to publish my edited "selects" instead of my full library.
Now if only there was a real F/LOSS contender to replace FCPX...
[0] https://www.digikam.org/
[1] https://rawtherapee.com/
[2] https://www.darktable.org/