Issue you're facing is mostly because of either of these two reasons:
- MTP acts retarded when there are too many files
- Windows acts dumb sometimes (switch to linux)
I don't really have a solution to either than switching to linux (as i did) for the latter
Now some REAL workaround to HELP you:
- Connect Your phone and computer to same WiFi/hotspot or even connect your pc to the same mobile's hotspot
- Download MixPlorer or any other file manager with FTP on your android device
then follow this guide
https://manyandroid.app/android-ftp-file-transfer-mixplorer/
Trust me learning to transfer file this way would just be a one time investment, this setup will help you forever!
/sdcard
shared folder does not contain too many files (less than may be ~1000).