I’ve never used anything that’s everything proof but I have a favorite on Amazon. This one has a power supply built in (no power bricks hogging the power strip). It has a physical on/off switch and uses simple USB cables. No downsides whatsoever, and after I bought one, I only buy these from now on.
“External Hard Drive Enclosure VSVABEFV” search that on Amazon.
They say they support up to 8 TB but I’ve gotten 16 TB drives to work.
If you have thousands of small files, maybe put them into the zip folders with store compression. A small number of large files read and write a lot faster than a lot of small files.