Oh I forgot to mention I have 3x 1TB External HDDs in addition which I use for back ups.
If my HDD fails (usually you get a warning sign such as audible sound being emitted from a drive), you still have that crucial chance to back up your data. It happened to me on my Seagate 2TB drive before. I heard the infamous clicking sound, but I was able to recover my data and had enough time to do so.
In addition after that experience, I bought a HDD enclosure. The reason being is just in case the HDD drive isn't accessible via being connected to the PC, it might be still accessible via USB interface. Nothing hurt to have another extra attempt you can use which is handy.
Hard Disk Drives are more forgiving and tell you signs if they are about to fail unlike SSDs.
SSDs however its either a 1 or a 0. Think binary. It either works, or it doesn't work. It is so much more unforgiving such that I don't trust to put my data there due to the lesser chance of recovery. The only reason why I would vouch for SSD is to utilize its blazing speeds which would be beneficial for faster boot times. In a productivity or workstation environment, time is money so you're accumulating saved time over time by using SSDs. But for launching games, I personally can bear the extra +10 second wait
if I load the game from a HDD rather than a SSD. Its not a deal breaker to me.
But I would still attest to the durability of hard drives, even though they're slower than SSDs. You can also get as much as 18TB capacity without the problem of overheating whereas for SSDs , it is hard to increase its capacity as you'd also increase the number of NAND flash chips present given such a small printed circuit board area available. This would in turn of course, increase its heat signature and lessen its longevity in the long run, because you've basically added more heat producing components to the PCB of the SSD.
I also personally have a Samsung 500GB Hard Disk drive that's over 10 years old and its still working normally today. SMART metrics indicate that the drive is still in good condition. I've used that drive for over 10 years straight as my boot drive, never abused it though with too much writes/reads. On the other hand, I have yet to experience any of my SSDs last longer than 3 years. I do see the fair occasion of people concerned about the heat signatures of SSDs be it SATA SSD or M.2 NVMe SSD. Its mainly due to the heat output, which inevitably you can't really escape unless you do some serious cooling on the controller (such as water block cooling it).
For me, newer technologies need to prove their worth before being able to confidently attest to their longevity. HDDs have been around longer than SSDs and yes some do fail, but ultimately I would say its much more forgiving in terms of recovery with HDDs compared to SSDs.
And to top it all of that, with PCI-E 5.0, it would be interesting to see how thermals get managed on future SSDs. The faster the controller's write speeds, the more heat is produced. Its just how it is. Maybe it would come to a point that water cooling M.2 NVMe SSDs may be mandatory once they near PCI-E 5.0 speed limit.