I'll certainly concede that they've gotten better, but they're still less reliable than a standard spinner or SSD. About the biggest one on the market right now is the Seagate Firecuda. Just go look at some of the reviews.
To be honest, with current SSD prices, the SSHD's almost have no real market anymore. At least the prices just before the human malware outbreak.
You know how they portrayed United Airlines for years, filtering down to 2 security guards dragging the doctor out of his seat, along the carpet and out the plane because he wasn't willing to give up his seat. Reviews of United Airlines were mostly bad, garnering a 1.5 star on google, but still doesn't deter people from flying United except maybe COVID. My experience with United Airlines over the past decade either flying on business and pleasure had been very good. In fact, like the Seagate issues, I just didn't see it. In fact, over a decade, it was mostly uneventful and I would give them a 4 star out of 5, and in some flights, I would be happy with the service and yet another person in the same flight felt miserable and then took upon him/herself to write a negative review. I don't have an explanation as to why, but I believe it comes down to his/her reality as opposed to my own reality.
As I said earlier; people create their own reality and the reviews are in instances a view into their own personal lives and personal psychology. Everyone has a certain expectation on the products they buy, and unless we have a way to read into their psychology, we need to understand that reviews review products based on their own personal psychology and the roles they defined for themselves and rate the products or review the products based on that role. It could be many things and perhaps the Seagate drive didn't meet that expectation, a proper SSD would. There are many variables when it comes to reviews and I had come to my own personal conclusion that, I will take any reviews simply as a guide, not a gospel, not the final truth. Look at what happened if you had followed Carl Icahn and put all your life savings into Hertz, if a person believes Carl has the final say or truth in investing money; then you'll be broke after COVID 19.
But it's true also that SSDs nowadays are affordable which make SSHD redundant. But I paid $15 for 750Gb used and $10 for the 500Gb used and $89 for the last one which I bought new. The people who sold me those used drives all sold because of the bad reviews and they had every motivation to quickly dump them. Thank you again for the fear mongering reviewers, allowing me to buy their distress assets because nobody else wants to deal with it with a ten foot pole.
