Hi there!
The short version:
The insync implementation of insync-nautilus causes extremely long waits when opening folders with lots of files. This does not happen with Dropbox.
The long version:
I was struggling with >1 minute waits to open a folder with ~15K csv files, and thought it was related to https://bugs.launchpad.net/ubuntu/+source/nautilus/+bug/869793 and/or https://gitlab.gnome.org/GNOME/nautilus/-/issues/978.
But after some testing I realized when I opened the same folder with insync closed, the time went down to a couple seconds. I thought it could be the icon badges (green ticks) insync shows, so I tried uninstalling insync-nautilus and leaving insync open, and the wait time remained a couple seconds.
Then, I copied the same folder to Dropbox (it also shows badges). But the issue did not happen there. It seems the Dropbox implementation is different, as it starts showing the badges after the files are shown.
I hope you can take a look.
Cheers