It makes I/O faster. If you are limited by encoding power (instead of I/O speed), then no, it wouldn't do anything for you. Sounds like a good test someone should run - maybe I'll try it when I get home.
Sandforce drives are slower on pre-compressed files, like encoded videos, than on normal data. But if you're editing raw video, they are extremely fast since raw video has not yet been encoded and is extremely compressible.
If you are going to work with videos that have been encoded already, Crucial or Intel will serve you well.