I still have one SATA SSD left over, its a 480 gig Sandisk that I bought years ago and it will work OK in a computer with both power and SATA cables but not in an external case with only a USB3 cable. I have in the past used a 1tb SATA SSD in a plugin case but this old one seems to need more power to run.
I would not buy another SATA SSD as the Samsung NVMe drives are far faster, 500-550 meg/sec versus 3.2 - 3.6 gig/sec and this is on gen 3 boards and chipsets. Some of the gen 4 SSDs are faster again if the board and chipset properly support it.
Magnus,
The old IDE (about 1990) HDDs were treacherous things, just a slight bump and they would start to show errors before failing. Back then I use ESDI drives and later SCSI as they were far more reliable. The modern HDDs are a lot better and the price is falling out of them. I have added a number of Seagate 8tb HDDs to handle bulk storage but still maintain being careful handling them, never drop them and don't bump them.
My latest effort to present reliable access to data for everything plugged into the LAN is an Apache server on a Windows network as I have both network and http access. Its behind the NAT of the router and the Windows firewall so its safe enough.