Shoebox can add categories to the keywords of your photos, allowing you to search the contents of photos using Spotlight. You can also create smart folders from categories or searches.

In the Categories preferences, you can choose whether you want to add categories to keywords automatically. Otherwise, you can add them manually by choosing Photos ▶ Keywords ▶ Add Categories to Keywords.