iCloud folders not appearing in the Mac Finder
Solution 1:
In the end, after a couple of hours of frustration, I solved my problem by: Opening Finder > Finder Preferences > iCloud and uncheck all the options (on my Mac these were iCloud Drive, Desktop and Documents). Close preferences, reopen and recheck the same boxes. The files and folders reappeared in my finder.