When you compare the capabilities and the cost it seems like it's a no brainer to go with SSD unless it's archival in which case I'm pretty sure a spinning disk that spends most of its life asleep will last longer than 10 years assuming that grease and other critical components don't get critically fragile merely by age (if it takes heat plus work plus time then sleeping drives are cooler and will last longer).