Switch to a distro lineage whose package manager builds in the necessary facilities? Someone’s already mentioned Nix, and Gentoo has the --fetchonly
switch for Portage which will download (but not install) everything required for a specified package including dependencies, so you can copy all of the files to an external drive at once.
My experience (which is admittedly many years out-of-date) is that WINE isn’t very good at anything except games, because games are what the people who use it and work on it are most interested in. When other software works, it tends to be as much by coincidence as anything.