Is there something like ID3 tags for pictures?
I know next to nothing about photography, so maybe there tons of tools out there to manage your photo library EXIF tags that I have never noticed.
So what I do is store a ".meta" file in the directory of each set of photos. That contains "location=" and "tags=foo,bar". Then I have a wee shell script to search.
If I need to I can have ".meta.IMG_FOO.CR3" to store per-picture data. But generally I order by date + location anyway, so having one file in a directory works out well.