My machine is built specifically for video editing, animation and photo work. I replaced my boot drive with a Crucial M4 256GB SSD and found that it didn't have any effect on video editing, but made boot-up and app launches a lot faster. It only takes up 95GB of space, since all my music and other storage-y stuff is located on a 4TB Hitachi 5K4000 HDD. That data is also backed up on another disk.
I still use a dedicated HDD RAID-0 for scratch, and an external RAID-6 for working data and larger scratch / temp files. The internal RAID-0 does 215MB/sec and the external RAID-6 does 816MB/sec writes, 714MB/sec reads, so that's my fastest disk volume by far. This is all I need to edit / playback / scrub native DSLR footage without even rendering previews.
I also have a little script that I copy/paste into Terminal that builds a 1.8GB RAM disk for scratch when I want better Photoshop performance. Since I have 32GB of RAM, this makes more sense than using an SSD for scratch.
What I *do* use my second SSD for is a clone of my boot / OS disk. This way, if the boot SSD dies, I have another ready to drop in. I clone this SSD daily. I use my original 640GB boot HDD as a third clone that I don't update until major updates (like 10.6.7 to 10.6.8, or CS5 to CS5.5) are verified as good. This way, I can revert to an old boot in case an update manages to jack up my system.
I noticed recently that I have twenty-one separate disks right now, and I can connect every single one of them to my Mac at once. That's amazing to me.