You have to open firewall ports to the Synology box, unless you run wide open, which I don't think is a good idea. Unless you have a DMZ, you have outside traffic on your internal network. Synology can't fix that.
You are right. I am more worried about local web servers and local networks being compromised than I am about either Google Workspace being compromised or somebody at Google taking my images.
It doesn't work that way. All you have to do is join the free 'connect.to' service of Synology and they provide some sort of tunnel from their servers to the DiskStation through the CloudStation app. I do not know how it works exactly, although I wondered. If you cut the power to your DiskStation you get an email stating 'connection to ... was lost at ... time'.
I used to have a DMZ with a small Synology running a website where clients could order images while the large original files and database were on a large Synology on the local network. So I do know what you talk about, but this CloudStation scenario works differently.
Not by design. I don't know of anyone who has set out to design an unsafe VPN. VPN quality is variable, and hard for IT people to understand, especially if not widely implemented with many customers. I wouldn't necessarily trust Synology's implementation. Do you know where their technology came from?
If people can access the Synology-served photos from a web browser, it needs more than a VPN connection to the internet. If they are doing their own hosting for the web users, then the VPN connection is sufficient.
And I guess that as long as the Synology and other computers are on the local network the files never touch the Internet but are exchanged between the CloudStation apps on the Synology and the computers. As you also have to install a CloudStation app on each computer that want to participate.
Nothing. I thought people were saying that Synology did all the security, and the user didn't have to worry about it. I don't see how that's possible. The user needs to open the ports the Synology needs open, and figure out a way to not have those ports open to other boxes than the Synology boxes. That sounds like the user needs to be responsible for the security of the network.