No such animal.
Platter drives are more likely to fail than SSDs, but in general the largest capacity drives are still platter drives. Some drives are built for specific uses, such as NAS drives. These are rated for much high higher activity than your standard drive is. That being said, all drives fail, eventually. SSD drives won't have a mechanical failure, but they are suspectable to shorter life expectancy with extensive read/writes, especially on full drives. Most people don't experience an SSD failure due to this because they have usually migrated to a higher capacity SSD before that day comes.
Question about your usage... are your drives at or near capacity when they go corrupt? Drives need swap space to work with, a full drive is like suffocating its air.
To be fair, some corruption has zero to do with the drive itself, but rather the means in which you use to access and store data onto them. Improper mounting/dismounting and even backup software can be your most common culprits. Sometimes the old school method of backup works better in the long run than using backup software. As in, you manually copy the files you wish to store on them, rather than let some software decide how to store such information. If a backup gets corrupted, and they do, your drive isn't bad, your back up is.
Do you share your drives between multiple platforms (i.e. Windows, Mac, or Linux)? The format you choose needs to be friendly towards both. The sad truth is, each OS prefers their content to be stored in a format that is native to it, so NTFS for windows, APFS for Mac, et al. The formats which support multiple OSes sort of do it, but they can be unreliable at times. exFat for example. You format a drive in exFat on a Mac and the PC will likely have issue with it. Format it on a PC, and the Mac might. I have never had any issues with FAT, only exFAT has. If you work solely in one ecosystem, stick to the format it likes best (i.e. native to it).
A true backup scheme is having the same data stored on multiple drives, so that you have a "back up" in case the other ones fail. Most people tend to play with fire and rely solely on a single drive. May work for them, but the risk is there, nonetheless.
And disk fragmentation is real on a platter drive. Defragmenting helps with the capacity issues, but sometimes just copying the stuff directly to a new drive is the better solution since it doesn't have to find space to temporarily write stuff as it defragments.
Sorry no advice on what to get as it really depends on how you use them. Do you have a NAS, use backup software, have massive amounts of data to store, the list goes on.
