It depends on the application. For most of our projects Western Digital RE SATA drive work well. If we need a little more performance then move up to SAS and when we need top level performance, SSD. It also depends on budget and amount of storage needed.
One drawback that we've seen with SSD drives is that they seem to completely fail all at once. We've had non RAID SATA and SSD drives fail and have almost always been able to recover data from a failed SATA drive, but that hasn't been the case with failed SSD drives.
SSD drives we've used have been Intel and Samsung, depending on price and performance.