I don't know, online fsck and defragmentation might actually make it viable for storage of smaller files. I could certainly go for a filesystem that does that well; my collection of internet memes is burgeoning. :PBeing able to work with very large files much faster than ext3 is the only thing most desktop or even majority of file server users get out it.
Ignoring the seemingly paranoid aspects of the first part and the general cannot-parse-ness of the end there, you make a good point about SSDs changing the way we manage on-disk formats, at least in the near term. My thought is it's not inconceivable that an SSD-optimised ext4 will come out in the next year or so. Indeed, I rather expect that there are already people working on this issue. Though really, I expect the SSD to move away from the current NAND Flash in a few years anyway.UK spending 70 billion dollars a year to spy on it's citizens and all that other stuff all over the world that needs such huge databases is only people it will help. The filesystem isn't the danger it's the anaconda storage rewrite to support it and the new wozniak SSD's and general changes in storage hardware that are likely to occur over the next few years is where the PITA part of it to end users comes in.
If it weren't for all the success of late or rapid movement towards success the fail of this year to linux would be frightening.