Yeah, I don't know why the reviewers even marked it down on SP, it plays amazingly anyway. I really enjoyed it, some missions get you involved in other things besides just foot infantry in a more direct way which COD had never done, was a good change of pace and had several iconic moments for me, the free fall was pretty bad ass.
After all the fuss of the graphics in comparison to PC, with the HD textures at least, the game looked amazing to me, the lighting deserves special mention. Am still yet to play the Co-Op missions, but my mate will probably join in on that some point soon.
Online, regarding destruction, I thought it was pretty decent, I forgot the level, but I was in a building overlooking a control point, and the opposite had a road in the middle, buildings either side, which were blown to bits, the rubble formed a barrier in the road, was pretty awesome.