SM-6's suck against MIG-29s, LCSs wont last long when the surface-to-surface missiles start flying, and the US is in desperate need of better surface-to-surface capability.
I'd expect to see SAMs become significantly deadlier once (eventually, assuming that it's a goal for the devs) energy is taken into account -- an aircraft that's burned all its energy evading the first missile should have a MUCH harder time evading the second! That's one of the big things you can take away from DCS and BMS: one missile is deadly, but two missiles are far deadlier than one.
It's interesting to see how different the missile capabilities are in those sims compared to Command. In BMS, an R-77 or AMRAAM fired at long range can generally be avoided if you're on the ball and expecting it, but if you're well within their envelope there isn't much you can do about it and you're dead the majority of the time.
Trying to dodge shots from an SA-10 or Patriot is essentially impossible, too -- there's effectively no warning as to when the incoming missile will arrive, as neither system will appear do be doing anything more than tracking you normally until the missile hits. Even if you know that it's coming (if you saw the launch and can follow the smoke trail), your chances are really only as good as they are at dodging an AMRAAM or R-77 (i.e. dismal).
As for surface-to-surface capability: if you're the US, that's what your submarines and planes are for! I think it's a doctrinal difference, really; the Soviets didn't expect to be able to field naval airpower in numbers that could reliably overwhelm carrier groups, so they developed long range ASMs to deliver conventional and nuclear weapons instead.
Harpoons aren't awful, but why launch a few harpoons from your ship and give away your position when you can use your submarines/aircraft to locate and sink enemies without them ever getting close enough to be a problem in the first place? Remember, aircraft give you a HUGE detection advantage. If you can shut down the enemy's air or at least contain it, you can merrily sail around over his radar horizon while alpha striking him with giant groups of aircraft.
...well, until he nukes you, but that's another story.