I just upgraded my MBP and opted for the slowest 2.0 Ghz CPU and spent the savings on 8Gb RAM and a Vertex 3. Absolutely worth it.
Just to give a rough idea - 4k random writes:
Vertex 3 - 214 MB/s
WD VelociRaptor - 1.9 MB/s
http://images.anandtech.com/graphs/graph4256/36481.png
A fast CPU is worthless if you're burning 30% of your cycles waiting for the HDD to deliver your data. Relying on file cache is not good enough.