Thank you for mentioning this! That's utterly terrible. I have had a Synology for years but never got around to trying the Photos app. This makes me not want to bother trying.
Personally I'm running a combination of Google Photos, Ente and syncthing.
Might have a look Immich, first time I'm hearing about it.