I've done a couple of test a few months back with two different SSDs (64 and 128 GB) and I've failed to see any noticeable performance improvement. Frankly - considering the cost and capacity of the normal hard drives this is hardly benefitial at all. Also - the speed up by backing up games from BD to HDD is already sufficient and I doubt that even full speed of the current hard drive is used all the time anyway.
So - in short to your answer - no, I don't think it will be worth it in terms of speed. Might be a bit less noisy but that's about it.