Just throwing it out there, even if you’re not running your own server or anything, if you happen to have two computers turned on at the same time occasionally, Syncthing is awesomely transparent and works VERY well. Crazy easy to set up too. (Like actually easy, not “network admin easy.”)
I personally run it on a little server at home now so it’s always on, and there’s a single “point of truth” where everything references the server, but you can have a number of devices that all simply ask each other what needs updating when they detect each other online. It can automatically retain versions, and that kind of thing. :)
Might also look into https://github.com/jstaf/onedriver !
I think both KDE and GNOME desktop environments might have integration with OneDrive as an option in their respective file browsers.
I remember KDE could work with Google Drive in that casual “download when you need it” way, rather than the traditional “sync mirrored copies” way.
Personally I’d say KDE is also a fantastic desktop environment for coming from Windows with little friction. I run OpenSUSE Tumbleweed personally, but Fedora has a KDE “spin” and I think Zorin uses it by default.
Hope this is helpful :)