I installed Dropbox for macOS on File Provider on my new iMac running the latest Sonoma OS. Your info states that the actual folder with my files is located at /Users/***/Library/CloudStorage/Dropbox. Here's what I found:
1. There is no /Library/CloudStorage/Dropbox located in my user folder.

2. Nor is there any /CloudStorage/Dropbox located in the users folder in my Macintosh drive.

Where are my actual files?
Are the files hidden?