My thoughts? Well, it's that a 460 is overkill for that application, but then in the test setup for the link I sent you they use a GTX 480 ^_^. The Quadro is more for 3d modeling and of course a big reason it costs so much more than it's desktop counterpart (a GT 240 or 430 about) is for the support. If you're going to spend a most of time in solid works then you may want to look at a quadro 2000, but otherwise I think the extra CUDA processing of the 460 would be appreciated in adobe CS 5.5.
The GTX 460 is at a good price right now so go for the 1GB version, though I guess the 768 version is fine too if you want to save a few bucks
. Just stay away from the cut down SE version.