Would I be better off going with an Nvidea based solution for PS? I heard that CS6 takes advantage of Cuda cores?
Cuda cores are overrated, If you have money buy a upper midrange card like 6950 or 7850 and a ssd to use for scratch/ catch disk. That will give you perfect performance. If the resolution was not so high I would have suggested a 6870 or 560 ti or even 6850.