Best workflow for Dropbox with new 10TB external HDD + SSD for video editing?

Hi everyone, I am a video editor working with large RAW footage files through Dropbox and I'm trying to optimize my storage setup after adding a new drive.

My setup is a newly purchased 10TB External HDD and a 2TB external SSD. The Dropbox folder is currently on the SSD because when I frist set everything up, the SSD was my only external drive.

Now that I have the 10 TB drive, I am considering moving the main Dropbox folder there to free up space on the SSD.

My proposed workflow is to move the dropbox folder to the 10TB HDD and let all synced files live there. When starting a project, I would manually copy the specific folder from the HDD to the SSD and edit directly from the SSD for performance. After finishing, I would move everything back to the HDD inside the dropbox folder for syncing.

My questions are:

Will it work?

Is this a stable and safe setup long term?

Are there risks if the external HDD disconnects while Dropbox is running?

Does anyone here use a similar HDD and SSD setup for video editing?

I am trying to balance performance and  storage efficiency without creating sync conflicts or data loss risk. I appreciate any advice from people who have experience managing large media files with Dropbox. Thanks.