If you want an app to catalog and curate your digital photo library with tags and albums, Find is a top contender. It's got powerful search, smart albums, object recognition and filters so you can quickly find what you're looking for. You can also create smart albums that automatically update and use Boolean operators for more sophisticated searches. It's designed to respect your privacy, running completely offline and using only native Apple APIs to handle photos in your library.
Another strong contender is Photomyne, which is good at digitizing and sprucing up family memories. It's got tools like auto-detect and crop, auto-rotate and perspective correction. You can also add tags, location data, dates and back-of-photo notes to photos and organize them into albums. The service has dedicated scanning apps and lets you share and print photos, too, so it's a good choice if you want a one-stop shop for cataloging and sharing.
ACDSee is another powerful cataloging tool, with facial recognition, advanced search and support for more than 700 RAW camera models. It's got AI-powered tools for things like replacing the sky and keywording photos. The software also has powerful photo editing tools, so it's a good choice if you want to catalog and edit your photos.
If you want an AI-based approach, try Applicate, which uses machine learning to categorize and tag your images. It's got automated tagging and the ability to create and save organized smart folders so you can quickly find what you're looking for. It's geared for creative pros who need to catalog lots of photos and screenshots.