I use cloud save and don't really have an issue unless the computer crashes or closes improperly. And then only maybe I might lose that current progress.

But for me it is super rare.

I live close to NYC and use only wired connections in the house. I think both of those do help. Wireless can be flaky for some things, I think especially for something like a background task of steam sync. Don't really know, just pure speculation on my part seeing as so many seem to complain while I have no issue.

I would say if you don't have any issues with cloud save in general go ahead and use it. Just make manual backups as well.... as you should anyway for important data.

There was an issue with cloud save and this game if you had multiple users use the same windows log in .. it would confuse the save files up. But that issue was just fixed in the latest patch.