The short answer is maybe, sort-of, kinda but not really. The idea itself is sound, but the reality is a little lacklustre with the end-result being essentially a standard hard drive. It may speed up some OS processes a little, but not enough to really justify them. You won't have a bad experience with them, but they won't make an appreciable difference.
My honest advice is to either a) get the biggest SSD you can, or b) get a ~128GB SSD for Windows/OS and a standard HDD for mass storage. The power of SSDs lies in the fact they have virtually no seek time, and they are the single most notable speed increase you can buy on a PC now, by leaps and bounds. Years ago one would have said get more memory or faster processor, but neither of those upgrades will have the level of impact on performance as going from HDD to SSD. Programs open almost instantly, Windows loads in < 30s, folders you double click simply open.
As I said, you could buy a hybrid, but it doesn't do either job as well as its traditional counterparts. The main advantages are cost-saving vs SSD (tho it's slightly more costly than an HDD), greater capacity than SSDs and significantly, no "management" of multiple drives, picking what data goes where. From the OSs point of view, the two volumes are transparent and behave as a single drive which is very nice. Eventually it will "learn" what is used most and those things will load up faster but for the most part, it will perform as a normal HDD.
I would honestly recommend getting an SSD, or SSD/HDD pair rather than a hybrid. I do appreciate that cost and/or simplicity may be desirable but the level of performance you'll experience from an SSD is unrivalled and makes HDDs seem like using ancient technology in comparison. They have come down in cost a lot as their popularity has grown so they are affordable. It just comes down to your mass storage requirements. Consider how you store/wish to store and access your media/photos/music/documents/etc, the level of performance you'd like, maximum budget and we can find a solution.