Why can't I open the Creative Cloud folder in terminal
To access the folder Creative Cloud Files you have to escape spaces in the folder name:

cd Creative\ Cloud\ Files


or use quotation marks:

cd "Creative Cloud Files"


You can also use the tab key after entering the first letters which will then auto-expand the folder name if the entered string is unique in the directory:

cd Cre tab which will expand to cd Creative\ Cloud\ Files/then.

If the same directory also contains a folder e.g. Credentials you have to enter an additional character (which makes the string unique) to get an auto-completed folder name.