Just had a thought, but I'd love to see apps become "Fusion aware" in the future. (Just like how now some apps take more advantage of multiple cores than they otherwise might.)
For example, I'd love to hear that something like Aperture could be made to keep this month's imported photos on the SSD no matter what and then move all others to the HD. Whereas the OS might think "oh, he only edited half of these photos, I'll move the rest to the HD" it would be great if an App could override that and say "nope, he told me keep ALL of this month's photos ready on the SSD for when he needs to work!"