I'd recommend an SSD for your boot drive and a 1TB drive in the ODD slot. I understand an SSD for applications, but getting a massive SSD just to store media files (like pictures) doesn't make a lot of sense to me.
I do some video work and editing in After Effects, recording off of a dSLR @ 1080p with file sizes in the gigabytes for only 5-10 minutes worth of video (uncompressed).
An SSD drive would be AMAZING to use for accessing and rendering.
Then theres also my images from the dSLR, which come out to sometimes 30mb per single photo. A library of 1000 shots in a single photoshoot is a pain in the ass to work with sometimes when doing batch processing or even simple image viewing (luckily i use Xee which has pre-caching).
My setup is a 120gb Intel 320 SSD for my OS X boot disk with applications and a 1TB Western Digital in the optical bay partitioned in two; 850gb for storage of projects, movies, music, etc. and 150gb for Windows 7.
I wouldnt mind the 1TB to be an SSD drive, would also mean less heat, less battery consumption, less noise, less weight (slightly) and faster speeds along with better reliability.
The cost does suck. Id prefer a slower SSD drive at a lower price if they made one at 1TB.
----------
SSDs are still new enough that nobody really knows what their true reliability is in the real world. Yes they are blazing fast but they also have issues that standard platter-based hard drives don't have (i.e., TRIM).
TRIM is only an Apple problem because they dont like to incorporate standards that werent set out by Apple itself.
Its rather disgusting, really. Apple has been selling laptops with SSD drives for a number of years now and only recently have they added TRIM and ONLY to their own branded drives.