The Hybrid HDD or SSHD as Seagate labels them, are a good option if you need a single system drive with a decent amount of storage. If you are looking for a data only drive that won't require a higher level of performance... I tend to lean toward a traditional HDD. If this will be your boot drive with applications, you will see a good benefit.
As mentioned above a boot SSD and Data HDD is still the best option. However, I understand that sometimes that is not an option or preferred.
I actually used one of the first Seagate hybid drives in my PS3. It's a Momentus XT 500GB with a 4GB of SLC cache. I must say it performs very well.