I just tested a theory by killing the Dropbox process; File manager navigations is still very slow. This makes me think that the issue is down to the Windows 11 upgrade and probably nothing to do with Dropbox. I'll try asking my question on the MS forum and I'll report back if there is a solution.