I use a wireless "Mifi" metered internet connection at home and while traveling on a laptop I periodically also use on various unmetered wireless connections.
Unfortunately, the DropBox desktop application is one of those applications that does not respect the Windows "Metered connection" setting. Even though I've set my Mifi connection to "metered", DropBox thinks nothing of quietly burning my entire data allowance downloading things I could wait for ab unmetered connection to download.
DropBox also has no "pause and stay paused until unpause" feature I can find. Using software more modern and respectful of user choices than Dropbox isn't practical in the short term because I'm on many shared family, work and other folders shared with many people - too many people would have to change.
I've seen a possible option here, on a question that is similar but is not specific to DropBox or to wireless metered connections, but that only works for that user because (unlike me) their metered connections are also all cable/LAN connections. Mine is wireless.
I've tried disabling DropBox from auto-starting by unticking
Start dropbox on system startup in dropbox preferences, but DropBox then still likes to start up uninvited when I connect anyway, quietly appearing in the system tray quietly downloading gigabytes...
My current workaround is to use a firewall that monitors data usage (I'm using Glasswire, which is really easy to use), and forbid dropbox from using the network until I manually re-allow it. However this is open to user error (I could easily forget to untick this when I finish using unmetered wifi), and some applications sneak past firewalls like this by running as a service and pigbacking on "Host process for Windows services", so it's not foolproof.