For DVD authoring i found a significant improvement from having the source and destination as RAM, as with GPU rendering, the hard drive was the only bottleneck (something like 700FPS vs about 280)
For much else, not really, and windows 7 with a lot of memory, combined with intel's sata chipset read/write cache results in some funny quirks that come very close to mimicking a ram drive in the background, e.g. i cant explain why, but every time i copy a block of files smaller than the amount of free ram, the transfer rate will initially be the speed of my raid array copying to ram, then trickle off to the speed of wherever else the file is being copied, be it a usb thumbdrive or network, (580 MBps to a usb2 thumb-drive does seem a little impossible)
Other stuff i have played with is for panorama stitching, but i feel its really going to be situations where access time or hard drive bandwidth are the bottlenecks in the situation, and with compiling i cannot imagine there would be much going on after the files involved get pre-cached to ram,