So my crystal ball predicts the adoption of tiered setups. Anything that needs the performance bad enough to justify the cost will buy SSDs. HDDs will slowly be pushed into secondary "bulk storage" roles, then finally to backup and archival.
Actually, for a long time if you requested aerial image data from the USGS, an automated tape library would copy the desired data to hard drive, and then you could download it. It was always hard to find that site (obviously you don't want Google crawling a tape library), and I can't find it now if it still exists.
Granted you may have been referring to actual integrated hardware, but I think such an automated system is close enough.
Hybrid drives aim to bring together the (cheap) capacity of hard drives and the speed of SSDs.
But for the sake of it, let's run the numbers.
A 700GB drive being written at 2GB/s would fully cycle in 350 seconds. That's 86400/350 is 247 cycles a day (amusing 247 ~ 24/7 coincidence spotted).
Assuming a 10,000 cycle life, that's 40 days of operation. Go to 100,000 cycle life and that a 400 day lifetime of non-stop full-speed writing.
And worth every sweet cent of that somewhat short life, in this commenters opinion. I'm sure that the half rack of HD's it'd take to get this kind of IOPs wouldn't have an in any way improved expected lifetime cost. If you just need throughput the story may be a little different.
It's easy to maintain overall device reliability (and performance) by having more spare area, but that negates a lot of the benefit of moving to a smaller process. (And the performance penalty from having fewer flash chips to stripe across for a given drive size also detracts from the smaller process size.)
Not only that, but the write endurance failure mode is benign: the drive simply becomes read only.
There's a huge gap in between.
Hybrid SSD/HDD drives were supposed to fill that niche, but they are still pretty crappy, they don't really solve any HDD problems.