Sounds like you haven't been using ADB. Normally, like you've seen, getting files on or off a modern Android handset is a terrible experience. Considering I only do bulk transfers from my own PC, I just apt install adb, then adb push $files $destination. Highly recommend - it's one of the few ways Android is still dramatically better for techy users.