Comment by nicoburns

I haven't used it in a decade, but when I last did need this kind of software IdImager's Photo Supreme came out top of my research.

The photo editing capabilities were relatively weak (but it would integrate nicely with the editing software of your choice), but the cataloging capabilities were fantastic, and it had a lot of flexibility about how the files were stored on disk (have it organise that for you or not) and the option to store the metadata it created directly in the metadata of photo files themselves where much of it could be read by other software.

https://www.idimager.com/