SSHDs are a pretty decent middle ground between a HDD & SSD, and make sense if you have a large library of games and programs but don't have the budget for a large SSD. They use a variety of techniques to try and keep the regularly accessed and performance sensitive data on the flash storage. Let's say you open Photoshop or a particular game a lot, the drive will quickly learn that you want that data and it will load close to as fast as it would off a native SSD.
The problem with an SSHD is that if you decide to open a different program or game that you haven't used for ages, it's likely that all the relevant data will have been shifted off onto the mechanical storage and it won't load any faster than it would off a standard HDD. The second time it'll load fast, but not the first.
That's the trade off you make going with a much cheaper SSHD over a large SSD.
bliq makes a good point. Are you sure you need 1TB for games+programs? That's a lot? Steam makes it pretty easy to move games around. With a little effort you could probably make do with a smaller SSD and a HDD and manually put your current favourite games on the SSD, keeping your archive on the HDD. If that sounds like too much hassle, then the automated SSHD is probably your best option.