Yes, I don't think it makes a huge deal with SSDs and databases, but it definitely gives you increased performance all around.
SQL Standard gives you many advantages, but I still don't think it will solve the issues we are having until 8.3. Given, there will always be an upgrade path to 8.3, if you have 8.2.2, you can just sit tight for a bit. Except for those with severe performance issues.
One thing for sure; it is MUCH easier to convert from 2012 Express to 2012 Standard as it is actually designed to allow that. But, it is costly, and then one day AC will move up to 2014. God please don't, lol.