Cowork can also use the data in that folder to create new projects -- but it's still in early access, so be cautious.
Use your cloud storage like a local folder. Keep your files private on any cloud provider with crypt remotes. Don't give up features or comfort just because it runs on a phone.
Both OneDrive and Google Drive are convenient, integrated (on Windows and Android, respectively), and get the job done. But ...