I use Lightroom and rarely, Photoshop
Then your gain from more than a moderate video card will be much less than if it was supported. Though, LR can't go on forever without dedicated GPU tasking.. maybe the next full version or the one after that at the latest.
You'll also want to take into account if you'll be using 10 bits or not. (the newest high end monitors support 10 bit). So far no game type cards support 10 bit, only workstation cards do.
IF you're not using 10 bit or you don't know what it is.. based on LR being your primary use.. then a 6850-6870 ATI card or a like Nvidia should be more than adequate. And still cheap enough where it won't hurt to upgrade later if LR starts supporting dedicated GPU tasking or if you upgrade monitors.