My experience is anecdotal, but as a general consumer using these drives in a home environment, HDDs simply have not been kind to me over the years.
On the other hand, I just had my first SSD (Samsung 850 Evo) fail on me yesterday, after chugging along for about 7 years. Compared to numerous hard drive failures over the years, to the point that I've made a rule to keep my workstation hard drive free for most of the last decade.
It started out as intermittent I/O errors, where the system would boot fine and run for a few hours and then lock up to the point where I could not even SSH into it. I tried replacing the cables and connecting to a different power cable but the problem remained.
Within a couple of days, the drive stopped being detected. I tried one last time using an external USB3-to-SATA enclosure but got the same outcome. I'm guessing that the controller gave out, as the wear level stats were fine last time I checked (a couple of weeks ago).
This was being used 24x7 for the last few years as a boot drive for my Proxmox server, for which I run nightly backups so I was back up and running within an hour or so after replacing the drive.
On the other hand, I just had my first SSD (Samsung 850 Evo) fail on me yesterday, after chugging along for about 7 years. Compared to numerous hard drive failures over the years, to the point that I've made a rule to keep my workstation hard drive free for most of the last decade.