Yes what can really kill a HDD is the number of power cycles. In particular, the number of head parking, which is sometimes worse.
I had drives from the infamous WD Green series at some point in my NAS (that I've replaced since) and had 2 of them fail (that resulted in no data loss as it was in a RAID array though). One specificity of the Green series is that they were constantly parking their head after short timeouts (to get in ultra-low power state) and it wasn't configurable, it was hard-coded in the firmware, so unless the drives were accessed 24/7 no stop, that would be pretty bad. That had killed thousands of these drives in the world. WD stopped selling them after a while.
From the list you posted, it kinda looks like the Seagate have the worst failurer rates overall, although it's a bit biased as they have used more of them than the other brands.