None of my data is on my system drive, so an SSD won't have a significant impact on throughput. Programs will load faster, but even with my technologically ancient IDE hard drive Excel loads in 1.4 seconds, MS Word takes 1.8. I see no likelihood of increased internet speed just because my storage device has no moving parts.
This is just one of those cases where you have to see the difference to believe it. SSDs really do make a noticeable difference to even day-to-day usage.
I think it is far too early to determine that SSDs are unreliable in average normal person usage. The StackOverflow guys who got so many failures in a year are:
a) a relatively small sample size
b) atypical users who are likely pounding their discs all day, every day
c) had no control group of users doing the same work on spinning platters
d) the commentors with lots of SSD were a self selecting sample who were likely looking for other people with lots of SSD failures
As my Intel SSD has just passed its first birthday, I've got my fingers crossed