I have updated all of our computers (except my 27" i7 iMac) with SSDs and the difference is stunning. The only reason that my iMac is not upgraded is because Apple does not offer it with an SSD... and I did not want to go through the hassle of opening up the machine to replace the drive... plus I need the 2TB of capacity on that particular machine.
Of course my i7 iMac is the most powerful computer that I own... which is very apparent whenever I do something like transcode a movie file. However... in regular daily use, it actually feels slower than my MBA which has an SSD. It is just not as "snappy" because of the ancient HDD. I enjoy the 2TB capacity, but I hate the way the HDD makes the computer feel slow whenever I launch a new application.
My wife and I each have 15" MBP's which I upgraded after the fact with 160GB SSDs. When I purchased my MBA, I ordered it with an SSD since I had no intention of opening the unit.
On our old windows desktop... I installed a 160GB SSD as the C: drive... and installed a 2TB D: drive which holds all of our documents, pictures, music, videos etc. That is the best of all worlds... with the SSD for the OS and applications, and the large HDD for data. If Apple offers a dual drive iMac in the future... I will decommission our new iMac and replace it with a dual drive (SSD/HDD combo) machine.
/Jim