JClosed: Let me start by saying I do not use anything "cloud" is it's in any form possible.
"Cloud" is just a fancy name for "data stored on a web server". The moment you posted this message here, you've already used a form of cloud.
JClosed: I never have trusted my files and information in hands of some computer that's located "somewhere" on this planet, in the hands of a unknown identity. Not only it does it not feels safe to preserve (any "cloud" provider can go "poof"), but also no one knows who has access to those files.
There are 3 aspects to data security:
1. Confidentiality: Aka. protection from theft. As you said, you have no idea who has access to that data, so clouds do not cover this. However, keep in mind that we're talking about game saves. Nobody cares if someone steals that data. You are not going to lose access to your bank account, nor is your rival going to steal your IP just because they have access to same game save data.
2. Integrity: Aka. protection from manipulation. Same as above.
3. Availability. Aka. backups. Cloud storage does, in fact, help cover this. You just need to remember that all media can (and will) fail, so you should never rely on just a single one. There's a reason why the 3-2-1 rule exists: at least 3 copies of the data on at least 2 different media, at least 1 of which is off-site. Cloud represents an easy and cheap way of having 1 additional media and 1 off-site location, and should not be so easily dismissed. If your house burned down and you lost all your data, having a copy in the cloud is infinitely better than not having it.
JClosed: Anyway - I can see it would be a problem for those games that need a cross-platform (online) save to function properly between platforms. But there also loads of games that will be perfectly fine with using local storage for those save files (storage is dirt cheap these day's).
I suggest to only offer cloud storage for those games that are cross platform and multiplayer. The other games can use local storage.
Ironically, you're suggesting the exact opposite of what any game dev would want/need/allow.
Cross-platform games do NOT use platform-specific cloud saves. Cross-platform means you could play on Steam and reuse the same save on GoG. Neither Steam nor GoG would ever allow each other to access their cloud saves. Any game dev that offers cross-platform saves therefore has to provide their own cloud storage solution that doesn't rely on GoG, Steam, Epic, XBL, SEN, NSO, etc. The only exception are games that support cross-platform between two console generations belonging to the same manufacturer, such as PS4-PS5 or XB1-XBSeries.
This is especially true for online mulltiplayer games. To prevent cheating, all online multiplayer games have to assume that the client is untrustworthy, including their saves. After all, players could easily mod their saves to give themselves a significant advantage that would kill the fun for other players. This is why online games never provide local saves.
JClosed: Do not forget that you can copy local stored games easily to another computer using a thumb stick or something like that. I do not know how that works with consoles though, because I don't own one, and have no intention to buy one either.
It works the same on consoles, and NOT having to do that is the whole point of cloud saves. Besides, do not forget that you CAN'T copy locally stored data once your device breaks down. Having cloud saves is better than not having them at all.