Why don't you use DS Photo from Synology? It's a bit dated but you can have auto upload of pictures and browse PhotoStation. We do, at home
1. It’s still a kind of vendor lock-in that I’m not crazy about
2. I’m generally underwhelmed by the synology apps (eg music) and prefer docker based foss alternatives when available
3. I was reading somewhere about DS moments (after another mention on this post) and I think they require a special folder structure?
2. Yeah, I only use DS Photo for backup / browsing on my phone. And Drive to replace Dropbox.
3. Not entirely sure about DS moments, as i use Photostation. In there it's basically each folder is an album (or sub/album).