What is better: 256GB SSD or 500GB HDD 7200rpm?

I'm in the process of buying a new MBP and I have a dilemma concerning hard disk. I have had a 128GB SSD drive in my Macbook Air and I was very satisfied with it, but now with the MBP 256GB seem really a bit short for all my applications (Final Cut Studio etc.).

I was wondering if anyone had already gone through this decision process: is the 256GB SSD so different and better than a 7200rpm 500 GB, the latter certainly being more suitable to my need for space?

Thank you for your help!