What version of macOS are you using?
Have you tried signing in/out using the Adobe Creative Cloud Desktop Application?
In the Adobe Creative Cloud Desktop Application when you click on Files in the left panel do you see any of your cloud files?
No issue opening Cloud Documents here on macOS Monterey 12.7.6 with Photoshop 2020 (ps ver 21.2.12) running on a 2008 Mac Pro.