Yes, you are entirely right in saying the databases are not opened from the sync store. That was sloppy language on my part. As you say, I open the databases locally and, in fact in my case, always want them then to sync to Dropbox.
Perhaps there is not precisely zero reason to have different sync stores for different databases where synced to the same location (eg one Dropbox account). But, on balance, I found I caught myself out by having two sync stores, because when I simultaneously synced one database to one sync store and synced a second database to a second sync store, both databases ended up showing in both sync stores (which was the opposite of what I intended when I set up more than one sync store). For that reason, I agree that it is best to have just one operational sync store in any given location.
I think I would be right in saying that if one has more than one sync store in the same location, it is important not to sync to more than one sync store at the same time, and, therefore, important to sync only databases that sync to the same sync store. I found myself forgetting to abide by that rule.
Do you see any logic in having duplicate sync stores in the same location? I could, for example, create a sync store entitled 31 August 2025 alongside my standard sync store. It would be a snapshot at that date in time, never to be accessed again except in case of emergency. After all, I have all that unused space on Dropbox. It is not a standard way to back things up. But is it actually illogical if it comes on top of other methods of backing up? You may say that this is misconceived, because, as you said before, you don’t open databases from a sync store, but instead sync to them. But in truth, you can download from a sync store. So in a convoluted way, you can, I think, open databases from a sync store even if that is not their purpose.
Taking that a step further, if you have databases you probably will never open again, you might decide to create a sync store for them, as well as backing them up in other ways. Or is that a heresy too far?