Windows 8 on the desktop does no such thing by default. If you're talking about SkyDrive, it works just like DropBox or Google Drive. You have to move your files in to a specific folder for it to sync to the cloud. Everything else, like "My Documents" and all the other stuff is still very much local.
Having never used a Surface RT, I have no idea how it works there, but on the desktop Windows 8 does not force you to store anything in the cloud.