I've synced terabytes with Dropbox no issue and know others doing the same. All others cloud sync products I've tested are much more flaky. Google drive was the worst and had many issues supporting others who decided they must use it.
Not sure what your dropbox issue is but I'd check you have the latest client, check you have granted file folder permissions to the app if using macos. First sync takes a while but performance is good after the first sync.