If you only have Sata II, go for a budget SSD as the port will limit the speed of any current SSD. Crucail MX100 for example. If you have Sata III, you should get the full benefit of the fastest SSDs.
But as mentioned above, comapred to a mechanical HD, any new SSD will seem blazing fast.