This folder was already synced on the cloud and I can see it is still there as I paused the syncing as soon as I realised I deleted the folder by mistake. How can I download the folder from the cloud storage to my machine?
When you delete a file / folder in the Creative Cloud Files folder it is moved to the Archive. The Archive is only visible from a browser at https://creative.adobe.com/archive. Select the file(s) / folder(s) you want to keep and select Restore to move them to the Files page at https://creative.adobe.com/files. They will then sync back down to the Creative Cloud Files folder on your computer.