In my opinion the 7200 RPM option is a good common middle ground if storage space or budget are of concern. Though to be honest, my new MBP came with a 5400 RPM drive and for basic use I don't really have anything to complain about but I'll likely be swapping it to a 7200 RPM drive soon.
7200RPM is often what people in audio production will go with, and thats a world where not only large storage capacity is needed, but also good through put and decent read/write speeds are a requirement so that there is no latency when monitoring the recordings.
The more I read about SSD, the more I keep coming back to this idea that the technology still has some developing to do, and as it gets better and storage capacities increase, the prices will likely drop too. There also seems to be some serious compatibility issues with OS X on the new MBP's (check these forums). Though to be fair there are some success stories as well.