The Q6600 is definitely the BEST price/performance for you atm.
Grab a Tuniq Tower 120 CPU cooler and overclock the heck out of it; you should be able to get 3.4 pretty easily.
TonyP is right, you will want help from your GPU. Look at the 8800 GTS (G92) or the 9800 GTX. They should do you fine, as well as keeping you within your $1000 budget.
As for the rest of the system...
Cooler Master Centurion 534 ATX Case
Gigabyte P35-DS3R motherboard
Crucial Ballistix memory
Corsair 550 VX/650 TX power supply
Seagate 7200.11 hard drive
This should end up around $1000. Priced on newegg.