For solid state drives a lot of the issues are firmware problems. Things like drives becoming very slow over time have been caused by things like imbalanced internal data structures. Some are media related, e.g. some drives experience slow reads on old writes, because the voltage levels have decayed which necessitates internal retries or slower read speeds. Things like SSDs failing to enumerate are probably controller issues.
In my experience both can fail either slowly, with degraded performance, or fast and total. However, known-good SSDs (most of Samsung, Intel) tend to be very reliable. Good hard drives too.
This is all among consumer drives though, enterprise stuff probably behaves better?
I'd love to see some kind of statistics on actual failure modes, but aside from Backblaze, everyone keeps their storage statistics private.
I’ve had to bounce around terabytes of crap on spinning rust for years. One nice XFS to XFS copy job took 2 days due to small files. Same thing on SSD was 3 hours.
I’ve also dealt with restoring a hosed 4 TiB NAS from another hard disk array. 4 days recovery sound like fun?
The 1tb NVMe Sabrent SSD on Amazon is $150: https://www.amazon.com/dp/B07LGF54XR/ref=cm_sw_r_other_apa_i...
You said you could put multiple in the PC so we can assume at least more than 1. So just for the SSDs, not including the NVM PCIe interface we are looking at $300 for 2TB.
In comparison for $100 you can get a 4TB WD red: https://www.amazon.com/dp/B083XVY99B/ref=cm_sw_r_other_apa_i...
That's a lot more $/GB than you could get with HDDs.
I have 4 2TB HDDs in a raid 5 array at home and all 4 disks didn't cost $300 and I have 6TB usable storage space.
So how is it cheaper to go with NVM SDD for home use?