Without going with the expensive extreme edition CPU the Q9650 is the best s775 CPU. The Q9550 is a great compromise for dollar to performance ratio.
If those are out of your price range then any Core2 duo or quad will be a great improvement over your current CPU. Just get the best you can afford.
Though you will likely need to update your BIOS for proper support for either one. Also a good idea to make sure the board supports your new CPU choice before purchasing. Though I can find the board still being sold at Newegg I cannot find it at Asus's site. You may need to shoot them an email to get a CPU support list and the latest BIOS.
8 Pro 64bit
AMD FX 8350
Asus Sabertooth 990FX R2.0
16GB G.Skill Sniper 1866MHz
OCZ Vertex 4 128GB SSD
HDD's 750GB x2/500GB/250GB
2x XFX 6870 1GB
12x BD-ROM
PC P&C 750W PSU
Cooler Master HAF 932 Red LED
CM Hyper 212 EVO w/2x SickleFlow 120mm Red LED
Logitech X540 5.1 Surround
2X Acer 23" LED - Eyefinity: 3840x1080
"The significant problems we face cannot be solved at the same level of thinking we were at when we created them."
- Albert Einstein