Or hopefully they will ditch SD for 2 really fast CFs
SD is where it's at for photo use. The latest SDXC cards are on par with high-end CF performance and they work in laptops. CF really has nothing going for it at this point apart from high-capacity designs for shooting video at high-bitrates.
I disagree - I prefer CF for its size, robustness and handling. The cards are big enough that I can change them out with one hand, toss one in my camera bag and be able to easily find it again. SD cards are a little more fiddly in that sense and easier to loose too.
Here's a borderline dumb question. Could manufacturers design a camera that uses solid state drives? Would that be faster than current transfer rates?
Solid state drives use flash memory just like memory cards. In fact a SSD is little more than a big memory card with advanced disk management to prevent the memory from breaking because of the same sectors being written to all the time. So technically speaking we already have SSD's in our camera's and the best thing about that is that they're easily exchanged when more capacity is needed