Only a select few games support it.....if a game does not support it, the card will do nothing for it....
A list of games running PhysX, both software(like console games) and hardware(the few that do...City of heroes does have a decent gain physx as does some mods for unreal 3)....
http://www.ageia.com/physx/titles.html