Anything 8800 GT and above really, with modernish cards as the main ones.
You can also get a significant Cuda boost if you use Cuda apps.
I've got to get around to build this media converting box for someone, made out of their old hardware. Theory being, they have a mobo with loads of pcie slots (the speeds aren't an issue), and something like 480, 285, 9800 and a 8800 - according to the software, if all the cards are listed within nvidia's driver panel as Cuda using, the encoder will take advantage of them all. Something to behold and I'll believe the results when I see them.
Physx is in more places than you may think.