Anyone have an SSD & HDD setup in their MacBook Pro?

Hi guys, I have a 2010 MBP with a 250GB HDD which is beginning to get full (music, movies, pics & videos of my kid, etc.), now it's beginning to get bogged down and sluggish I feel. I'm planning on removing the SuperDrive and installing a 64GB or 128GB SSD and changing the HDD to a 500GB or 1TB. Also, might upgrade the RAM as well since its so cheap.

Obviously I will be installing Mountain Lion on the SSD along with my main programs and apps, and using the HDD purely for storage of media.

My question is: How easy or hard is it to manage what gets saved to where? i.e. If I have iPhoto, for example, on the SSD will it always want to save my imported photos and video to the SSD by default? Then I would need to manually move it to the HDD? Or would I just be better installing iPhoto on the HDD?