I use Lightroom Classic. Subscription, yes, but I think it's worth it, and it's been very solid for me the last couple of decades. Has tons of tools too, really everything I need in a photo editor and library app.
I want to mention one thing I really like about Lightroom; it has two basic ways to view photos; 1. as they are sorted in folders on disk, and 2. as collections that I create in lightroom.
So my image folder has been bulding up over the years, and is organized in the way I've found natural at any time. There are folders for scans of old prints, scans of slides, digital photos by year, etc.
I rarely re-organize my basic photos folder - although I could, inside Lightroom, and it would be reflected in Finder view. Instead I use the collections view in LR to organize stuff. And the hierachy is totally different; i.e I might have a collection called "Family" and it might contain both old prints, slides, and raw files, just as an example. Of course, collections only references the photo files, nothing is duplicated.
I find this concept works very well for me. Another approach is to use keywords/tags, but I never really got into that .