NVidia have a list but they will mostly be Windows-only apps - the most prominent being the Badaboom video encoder. PhysX is a CUDA technology so any games that have PhysX use it such as Mafia 2 ( http://www.youtube.com/watch?v=ONQfbGBtitY
), Batman Arkham Asylum ( http://www.youtube.com/watch?v=vINH6Z9kqgI
), Metro 2033 etc.
The way to do GPU acceleration in a cross-platform way is OpenCL so a handful of Mac apps use this. Final Cut Pro X being one of them. I think it would be a good idea for the core frameworks in Lion to use OpenCL so that more apps can benefit from it with little effort.
Cuda is NVidia-only and AMD have the Stream SDK. OpenCL works on both so is the best choice. The area where it will become most visible is in visual effects packages like compositing and 3D engines. One rendering engine to use it is Small Lux GPU:http://www.youtube.com/watch?v=wPjsvA5f4pE
but a lot of them are starting to integrate some form of GPU acceleration because there's not much point in leaving a teraflop or two just sitting around unused.