Sounds like you don't have the correct permission on the folder if you cannot open the .psd files, either, when they are there.
Yeah I think the same too, but its in my creative cloud. and i did open the indd file before with no problems....
And for the psd problem i can still open the psd in Photoshop. but I get the same error when inserting the psd picture into the a indd Project.
I don't use the cloud storage, but from what I've heard it seems more like a beta product than ready for prime time.