It's gotten better in recent years.

Airdrop.

VLC on the iPad will expose a web server that you can connect to and upload.

Safari on iOS has a download manager as well.