Most of the time we see data loss from spinning disk failures more than anything. From time to time. we'll get SSDs but very very rare, we mostly see more OS drives than anything. But spinning disk are a common cause because there's moving parts and magnetic disks. Everything's moving. They’re more prone to failure.
But as far as performance wise I always say SSDs are the way to go because it will be blazing fast processing everything as much as possible without anything actually moving. But there's that whole cost-to-storage ratio we’ve gone over a few times here. So most of the focus is toward the drives more than anything because if a RAID controller goes out that can always be replaced and the data should be still on those drives.