Here is all you need to know about Physx:
http://physxinfo.com/index.php?p=gam&f=gpu
That's every gpu physx game ever released, there are 18 of them. 75% of them are utter trash, some of them are free demos, one of them is only using physx in a single level of the game.
That's 4 games a year for every year it's been around and even that is being generous considering some are free demos or it only works in a single level of one game (UT3) Two of them are sequels Hot Dance Party 1 and ... Hot Dance Party 2! lol
In short, physx is worthless trash and not worth considering when you are buying a video card. Innovative games like BFBC2, Crysis/Warhead and the upcoming BF3 continue to do impressive physics effects on the CPU.
Basically the superior price/performance of a $300 6970 that is 90% the speed of a $500 GTX 580 is worth a lot more than the 2 good games ever released that use physx. And don't forget you will take about a 35% framerate hit just to turn on the useless feature.
Physx wll disappear in a few more years if the notion of running physics on the GPU takes hold as a universal standard that works on any card emerges, likely openCL.