For Photoshop, you just need any CUDA-enabled graphics card from Nvidia that has
at least 850 MB of VRAM. If you only use it for that, then I would get something low powered. The Quadro cards more expensive and generally less powerful than GeForce cards. There are only two upsides to Quadro cards: (1) certain CAD programs require them, and (2) they support 10-bit monitors. The Adobe suite will work with GeForce cards (i.e. Adobe doesn't require Quadro cards). The remaining question is whether you have a 10-bit display. If you didn't spend several thousand dollars on a special monitor, you probably don't. If you do have one, it's worth it to get a Quadro; otherwise, GeForce will be a much better option for you.
In terms of a low power GeForce card, the new Nvidia GeForce GTX 750 ti is great for the Adobe suite, especially if you have a small power supply (i.e. 425w). The card only uses 75w and requires no power plugs. The EVGA Superclocked (SC) version has 2GB of VRAM, which is a good amount for your use. It's pretty fast and costs only $154 --
http://www.newegg.com/Product/Product.aspx?Item=N82E16814487024
If you are planning to game, you'll be able to run low to medium details at 1080p, but you can also play max details at 720p. Overall, I'd recommend this card as stellar for Adobe suite usage, but point out that it is mid-range for gaming. It's small and uses very little power while delivering pretty solid performance.
Here is an article on enabling the video card acceleration on Photoshop CS6. Good luck!
http://www.studio1productions.com/Articles/PhotoShop.htm