The difference between dual and quad is not that big right now. An overclocked e8400 will crush the Q6600. Possibly the Q9650. I think its the best because the price is almost outrageous.
have fun with alan wake lol, i like my quad, and there isnt truely a bets cpu, there is only a cpu that best fits your needs imo for me it was a quad q6600.