That’s a big topic, and I don’t know how many reliable statistics there really are about it.
What I do know is that there are enterprise server drives, mid-range NAS drives, and desktop or workstation drives. Enterprise drives are meant to run 24/7 continuously in servers. NAS drives are more of a middle ground, intended for consumer or SMB NAS systems, typically with fewer drives in the enclosure compared to enterprise setups. While all of these drives support power-save modes and spin-downs, NAS and desktop drives are “designed” to spin down, whereas enterprise drives are designed to run continuously.
However, I highly doubt that consumer or NAS drives will last longer than an enterprise drive when spin-down is used, as lower-end drives are generally less durable. The benefits of NAS/workstation drives lies elsewhere in this context, for example, faster spin-up times, which might even cause more wear, but is, of course, necessary so you’re not waiting 10 to 15 seconds every time the drive is accessed.
Other factors matter too, like how much read/write activity there is. If nothing is being read or written, the read/write heads go into a parked position even if the platters don’t spin down, meaning no wear on the platters or heads. I’d say an enterprise drive with little to no read/write cycles could theoretically spin forever, while frequent spin-downs cause stress — not just to the motor, but also to the heads and platters.
Overall, I’d say enterprise drives are likely the most durable option, followed by mid-range/NAS drives. I’d avoid desktop drives for this use case. Whether you spin them down or not is up to you, but all drive types will probably last longer on average without the additional stress of constant spin-ups and spin-downs. That said, if you intend to spin them down, I’d probably go with mid-range consumer NAS drives, as they generally spin up faster than enterprise drives and are often quieter.
So, pick your poison, I guess. 