Remember caching disk controllers? Nothing's new under the sun. :-)
I expect more and more of this stuff to be pushed onto the silicon over time, but it's hard to beat rotating disks for hyrge storage. Presumably Intel and AMD and the motherboard people are working on ways to move the SSD off the hard drive and into the CPU/chipset/motherboard slot. More integration at lower levels should make it cheaper.
But, fully SSD storage is expensive and going to remain so. Most of us don't mess with more than a few 10s of GB of data and programs every day, but we want reasonably quick access to TB of stuff. A standard, cheap 64 GB SSD coupled to a TB+ hard drive would seem to be the way to go for the next few years (until everything is designed for 16 Mpixel screens anyway).
Let us know how it goes. Good luck.
Cheers,
Scott.