You'll probably see some improvement. I did when playing crysis, farcry and other fps games but that was paired with an hd4850 and later a 7850. Both are stronger gpu's than the 7900 gt. Check your gaming usage using something like msi afterburner and monitor cpu usage vs gpu usage. Chances are your gpu is the bottleneck and if the cpu is constantly below 80% use in most of your gaming then overclocking may not help much.
My e8400 was oc'd to 3.6ghz and served me well with an hd 4850, the 7850 created a slight cpu bottleneck. Looking back on old benchmark tests done on crysis, to achieve 50-60fps with the 8800gt/gtx it required turning down the eye candy to low quality even at 1024x768. At high quality those fps dropped to 30-40fps at...