I just spent 4 days explaining to Dropbox support going back and forth chat and emails with this issue, I even sent them a screen video of the problem from my computer. I confirm they are aware of this situation saying they are working on it. I honestly don't know if this will be fixed since Apple changed the main Dropbox folder to "Locations" in fact you have to download a program called Rosetta so Dropbox can work in your M1 or M2 Macbook, also being on "Locations" is making a link somehow to iCloud for what I can see; let's see if Dropbox team can resolve this the same way as other MacOS before Ventura worked perfectly.
Before asking Dropbox support, I did the same with Apple support, they heard and understood and they simply said is not their problem, their words: "everything is working as is supposed to", but what does this mean?? of course it isn't working, I mean they moved the folder to "Locations" not an option for users. I did my best to get them help me, I couldn't.
So after this I don't know who's the one to be judged, let's just hope any of both can help us out, we're hundred of thousands with this situation, everyday people using Dropbox is changing to Ventura.
Doing so many steps to open a file it just doesn't make sense...