To me, i look at the arguments for and against the 6950 in this way.
comparisons to the 570 are unfair because that card belongs in an upper price segment. The 6970 and 570 trade blows in a couple of games and the 570 dominates in "TWIMTBP" games, not surprisingly. But for a lot of people, the money saved by opting for the 6950, instead of the 6970, can be better spent of stuff like cooling for e.g.
But at the current 17K price segment, the 6950 2GB model is a phenomenal package, simply because i think the frame buffer advantage will come into play at the 1080 resolution as newer games are released (Skyrim wink wink). even if you don't game at 1600, the added frame buffer helps with AA and AF. Even if the 6950 to 6970 mod isn't stable or doable with your card, it has great performance on its own.
Tessellation is something that Nvidia are much better at than AMD and that's not going to change in the current generation. But with the 6xxx series, AMD aren't completely lost. But if Tessellation is such a game changer, then there is no choice than Nvidia.
Cuda vs stream has never been an issue for me as i only look at gaming. For me, transcoding isn't an issue, as i always leave my PC on all night for such purposes
So a half hour or 2 min session doesn't affect me when i'm asleep lol.
Now for Physx, from my understanding, when you enable it, except for the highest grade cards like the 480 or 580, your fps take a massive hit. The recommended way to enjoy Physx is to have a dedicated Nvidia card in addition to your GPU. Now that means additional investment in a card, bigger PSU, SLI or Xfire motherboard besides the potential for greater heating inside the cabinet.
And besides, There is no game out there that will not run without Physx enabled, simply because the installed user base isn't large enough. So every game currently can be run without Physx with the assurance that core gameplay elements won't be affected by its absence. Current implementation of Physx is mostly cosmetic, because no developer will take a risk and introduce controls that can only be implented with Physx. So if you decide not to go the Physx route, you haven't lost all that much really, besides watching debris, dust, cloth and papers fly, which to be honest, i don't give more than a cursory glance to when i am playing.
At the moment, if you've got the money for it, the 6950, more than the 6970, is unmatched for the performance you get in the price segment.
Of course, i could be wrong on a lot of things..