I dont think there is anything which is as good as Lightroom is. I share your cloud complaints. But Lightroom Classic doesnt save anything in the cloud. It saves your changes in a .lrcat file (and some folders) locally. For my workflow, with different devices, I put the saving files in my own Cloud (in my case dropbox).
I use the software Digikam. It allows different views on your images like: sorted by date, file structure, people (it has face detection, but it needs some manual improvements), by tags (you can tag your images with your own categories), by location (if your images saved the geo location.
I really like it alot and with the search function you’ll find old pictures very fast, IF you took your time to tag the images and let face detection run over all your images.
Edit: forgot to mention that its free and open source!