My main use case is all my audio recordings from my DAW - each take generates a small .wav and .reapeaks file. I use this as my live working folder - I read and write into my Dropbox folder while it's syncing.
These add up (more count- than total-size- wise). I currently have 378k files, 23k folders, 754 GB and Dropbox is the only client that hasn't skipped a beat with it (even before they rewrote it in rust - it used to be python???? insane). It runs well on a 10-year-old CPU and even ran well before I moved it to an SSD.
It's not perfect - onedrive keeps infinite document history, Dropbox a max of a year - but for anyone looking for sync performance I'd suggest looking at Dropbox first.