I built a system with an OCZ Vertex III SSD and i3-2120 about 4 months ago, used as HTPC and gaming and downloading, and i haven't experienced any slow down. Also had no problem installing windows 7 or ubuntu, did it like a normal HDD.
The performace is totally worth it. My system, with 4 months of use by 4 different people and 4 different user accts, still boots before the windows animation at boot up is finished. Unless you have the money for a big SSD, i would do what everyone else is doing and get a 128-256GB SSD for your system drive and a normal HDD for storage.