For Graphics, Yes you will see a very good performance increase.
Photoshop is more CPU and RAM dependent though, a new GPU won't help loading/filter times much to any at all. However, CS3 supposingly will take advantage of the GPU when it comes out (currently beta), but as it stands now you wont see much of a difference in CS2 or lower.