Anything USB connected more likely to be flaky, but a good enterprise disk shelf and a HBA card would be rock solid (just noisy…)

Unfortunately my solution when I did a big data migration was to buy more (cheap) storage lol. Ultimately it was a cost vs. time/stress tradeoff.