Any downsides to using Dropbox instead of CC File Sync?

This gets to be a really complicated subject pretty quickly. I wish Adobe would allow me to hitch my Creative Cloud account to use Dropbox as the storage provider for my photos because Adobe's storage plans suck for a photographer like me. I have terrabytes of storage available, easily half of it is stored with a vendor like Backblaze (B2) Wasabia and AWS (S3) and Dropbox, iCloud — buying yet another cloud storage service is not a great solution for this.

I read that the Creative Cloud storage space can be utilized in a way that the smartpreview files that I work on in Lightroom CC and Lightroom Classic don't go against the free tier quotas in the Photographer's subscription I use. So I came up witha workflow that lets me use Dropbox while away from my studio to upload photos into a Dropbox folder that syncs to my creative workstation at home. 

That workstation is running LR Classic and ingests photos flowing in from Dropbox while I'm traveling, my local working copies of photos and videos are on a zfs zpool for incredible integrity and recovery assurances on redundant storage (two pairs of mirrored NVME drives via Thunderbolt 3 in a two-way mirror of mirrored devices and it is every bit as awesome as it sounds) and is also backed up to another system at that residence and then also that gets backed up to S3 buckets or B2 object stores. No bitrot, no performance problems, assurance on integrity.

So apparently since my storage where my working copies of photos land is a workstation at a desk somewhere else those ablums and collections of photos end up in a sync'ed album and the smart preview jpegs are what i am working with on my iPad out in the world, and then when I need to send something out for prints or other purpose other than sharing on social media, I can remote to that mac and use Lightroom Classic to generate full sized images from  the source media.

This way I avoid a bill for Even More Redundant Storage (which frankly is a liability at this point) and I seem to be getting the benefit from using CC storage without addional cost. Smart previews are fine for sharing on social media or friends and family.

I got the inspiration for this and more detail from a few threads on reddit about using Adobe Cloud Storage in cost-effective ways. I would instantly toggle a box that let me keep my Lightroom working images on Dropbox or an object-storage service via their APIs if I could but I doubt that will be happening from Adobe. 

So of course...  Premiere Pro search can not locate the Dropbox folder location. This seems to be due to a recent update. The Dropbox folder that Premiere Pro can not search is:

MacIntosh HD\Users\[username]\Dropbox

How convenient...  I suspect other Adobe apps have this same "problem". And this is a problem with any Adobe app files stored on Google Drive. So it is starting to feel like Adobe is locking its users out from using any other cloud storage provider.

This is documented in other forum posts:

https://community.adobe.com/t5/premiere-pro-discussions/project-file-missing-dropbox/m-p/9357402

"I had the same problem. It's about the place in the folder where DROPBOX is keeping the files in the updated version. Premiere cannot access this "hidden" folder address. (User/Library/CloudStorage/Dropbox).

Now I can no longer see the dropbox folder to relink the files.

I had to move everything into another HD for it to work and for now I'm not using dropbox anymore.

I've already contacted Dropbox, and they didn't know how to solve the case. I also spoke with Adobe but this problem still doesn't have a solution apparently.

See the video of my case:

https://shared-assets.adobe.com/link/ecf707df-fd41-4433-5b3b-e72711234cfc

See this other case:
https://community.adobe.com/t5/premiere-pro-discussions/dropbox-cloudstorage-location/m-p/13151550 "

Given that Adobe is never going to implement selective folder/file sync, is there any downside or limitation to simply using Dropbox to sync files across multiple computers?

The main issue I keep in mind is the possibility of selective sync conflicts.

https://help.dropbox.com/sync/selective-sync-conflict

If you're using the same file or folder on Dropbox across multiple devices, such as perhaps a Lightroom catalog, if the sync has not completed on Device A before you open the same software on Device B, you may end up with multiple versions of the same file or folder in Dropbox.

there are some things adobe file sync can do that dropbox can't (like auto cc backup from apps like lightroom and photoshop), but not everyone considers that a plus.