Unfortunately, I did not understand your problem. The only thing that is certain is that if people used Dropbox before and now you want to build something on it like Nextcloud, Google Drive or Microsoft 365, then the users will always be dissatisfied. Your only choice is to either stay with Dropbox or switch completely to Nextcloud, Google Drive or Microsoft 365. Everything else is nonsense.
Nextcloud is really great. But Nextcloud combined with Dropbox is just terrible. But would also be the case with Dropbox combined with Google Drive or Microsoft 365. Interfaces between different cloud platforms have never been great. Only managers claim that this is quite possible.
Pay more money for more data at Dropbox. That is your solution. https://www.dropbox.com/plans (e.g. 10 euro for 2 TB a month)
Or change full to Nextcloud. Managed Nextcloud e.g. 5 euro for 500 GB or 10 euro for 1 TB a month e.g. in Germany. Advantage: you can change the Nextcloud provider if needed without changing the software
I would say use Dropbox integration App to connect to your small Dropbox from the Nextcloud and Import all the data from it. Than you can use Nextcloud with a lot of storage and remove all information from the Dropbox.
Working via Nextcloud with Dropbox as mentioned above is not satisfying and not recommended at all.