Synology Photos is nice, but its not for professionals. If you need like an absolute perfect solution with tons of features, its not for you.
Its perfect for family photos though.
You can sort photos by dates, create albums, create albums by person/object/scene. It has AI face / object recognition.
It’s 90% of what I need personally.
Why are you trying to do it the hard way?