I think the issue with cloud saves is that developers are pretty free to use them as they wish, and some of them wish to use them in craptastic ways.
I spent a couple of hours diagnosing why I couldn't get save files for a particular VN sync via the cloud between my Steam Deck and my gaming PC. Turns out that they implemented cloud saves so that Steam syncs the cloud saves to Location A on the file system, and when the game boots up, it checks if there's a save file in Location B, it loads that, and if there isn't, it copies the save file from Location A to Location B and then loads it. The end result was that all of my Steam Deck saves were on my gaming PC immediately after I installed the game on my gaming PC, but neither device ever refreshed the saves because the actual save location was different from the cloud sync location, and there was no mechanism to override local saves with cloud saves.
I spent a couple of hours diagnosing why I couldn't get save files for a particular VN sync via the cloud between my Steam Deck and my gaming PC. Turns out that they implemented cloud saves so that Steam syncs the cloud saves to Location A on the file system, and when the game boots up, it checks if there's a save file in Location B, it loads that, and if there isn't, it copies the save file from Location A to Location B and then loads it. The end result was that all of my Steam Deck saves were on my gaming PC immediately after I installed the game on my gaming PC, but neither device ever refreshed the saves because the actual save location was different from the cloud sync location, and there was no mechanism to override local saves with cloud saves.