The Tech Report has published a new solid state disk roundup, this new article features the latest batch of SSDs, including the Corsair Nova V128, Kingston SSDNow V+, Plextor PX-128M1S, and WD SiliconEdge Blue. You can read it over here, the best model in this roundup is the Corsair Nova V128, the reviewer says the all-around performance is at least on par with that of the Intel X25-M G2, and that it didn't suffer from crippling weaknesses.
I also want my ideal desktop to be as quiet as possible, which is why I'd move upmarket from the Sweeter Spot's single hard drive to a hybrid combo that melds an SSD with a pair of low-RPM mechanical hard drives running in a fault-tolerant RAID 1 array. This sort of setup isn't cheap, but it offers jaw-dropping performance backed by redundant mass storage that barely makes a peep.
Solid-state drives have been on the radar for a while now, but they've long been regarded as far too expensive to be practical, even with phenomenal performance. Prices have fallen dramatically in recent years, though, and we're finally at a point where it isn't so outlandish to consider seriously purchasing an SSD for a high-performance desktop PC.