While you appear to have a solid technical knowledge base, it is clear you have little to no practical knowledge or experience with SSDs other than off the cuff comments you've read here or there.
Let's go through some of your misconceptions shall we...
Price. Yes they are more expensive than mechanical hard drives. But the speed boost is substantial and worth it. I remember paying $200 for a 30GB HDD a long time ago. Now I can get a 128GB SSD for $160. My 128GB Crucial M4 is limited by my 3Gbs SATA 2 connection. It maxes out at ~280MB/sec for reads due to the pipe. It is actually much faster than that (over 400MB/sec fast). Pretty amazing difference for the otherwise slowest piece of hardware in any computer. Plus with TLC NAND arriving drives are going to start getting cheaper. Pair the cheaper flash with more mature controllers and within the next year or so SSDs will be in their prime.
Yes they are not tolerant of vast amount of write cycles. That is what wear levelling and TRIM are for. Even if new 25nm MLC flash could *only* handle 3000 write cycles, do you think you will ever use it that much? Highly unlikely. New Intel drives in the worst case scenarios running MySQL databases are still expected to last for a few years. Are home users ever going to continuously do 1TB of writes per day on an SSD? Most enterprise systems won't even touch that.
Mostly wrong about the swap file. Microsoft recommends putting the pagefile onto an SSD. See: http://blogs.msdn.com/b/e7/archive/2009/05/05/support-and-q-a-for-solid-state-drives-and.aspx
Take a look at SSD caching. In particular Intel Smart Response. It's a great way to get the speed benefit of SSDs much of the time with a lower cost.
You are dead wrong about SSD speed. Where did you even come up with those numbers? My USB 3.0 32GB flash drive reads at over 120MB/sec. As already stated my SSD totally maxes out 3gb/sec SATA: something mechanical HDDs can only do in RAID. And that's only talking about sequential reads/writes. I dare you to open up firefox, photoshop, and start a 1080p movie off of a mechanical HDD, and then off of an SSD. Access times on SSDs are near instant. See http://www.anandtech.com/show/2829/20
Yes SSDs are still relatively young and immature in some areas. That doesn't change the fact that support for them is substancial and they are above and beyond mechanical drives in anything related to performance.