Recommended graphic card : Super or no Super

In Photoshop the main consideration is reliability. Buggy drivers is a never ending curse. Clock performance isn't important, although a fair amount of VRAM is an advantage (preferably 4GB or more).

The GeForces are made for gamers, and that's their priority. To get the latest games to run they sometimes cut corners, and fix the bugs properly much later. For graphics/photography/CAD/3D NVidia make the Quadro line, with their own drivers. Quadros are generally much more reliable with Photoshop, although at a higher price at similar nominal specs.

In the video community the emphasis seems to be more on GPU performance, so they tend to use GeForces a lot. You should head over to the Premiere Pro forum to see how they do with that in terms of reliability.

Recently NVidia split their GeForce drivers into a gaming branch and a studio branch. You should definitely use the latter for Photoshop.

In Photoshop, You will nof find a difference using any of them.