I've been building a number of systems lately, and needed to put together a few of my own too. So in addition to building several servers based on newer Xeon chips, I also have had the pleasure of building two core 2 quad systems recently.
Intel's entire lineup of new chips have some real positives. The Intel Core 2 Quad Q9450 Quad-Core Processor, 2.66 GHz, 12M L2 Cache, 1333MHz FSB, LGA775 is a great chip in particular that offers you some of the benefits of a server CPU at a home PC price point. It's also very compatible with the types of boards and set-ups that most gamers or heavy application users (read Photoshop :) ) will want in their rigs.
Like the Xeon Quad-core - X3350, the 9450 also gives you the 12 MB of L2 Cache, which is the largest easily available through retail channels and 50% larger than the 6600. True, for $200 you can get the Intel Core 2 Quad Q6600 here on Amazon. It has a very similar clock speed (easily over-clocked) and a respectable 8 MB of L2 cache, which is nothing to sneeze at. Like I said, I used that guy in my personal box, but I did find that it was possible to locate the 9450 at a similar price. So while Amazon's price does vary, if you do your research you can get the larger cache and slightly faster clock speed of the 9450 for the same price as the 6600.
People building a home server that is pulling multiple duties or running multi-threading apps like Adobe Photoshop CS3 will benefit from the extra cores. Not to mention, if you have gotten away from 32 bit OS and moved to 64 bit (Either Vista x64, Linux, Solaris, Suse, or another one) you will definitely be able to squeeze some extra juice out of the extra hardware.
Unlike the Xeon, this guy isn't compatible with the 3200 board architecture that gives you ECC DDR2 800 ram and some other extras. So while that makes the Xeon better for server specific applications, the 9450 is definitely comparable in performance for all other functions.
The LGA775 architecture is somewhat standard for Intel's core-2 quads. You get support for a 1333 FSB. Once again, with a 64 bit OS you get to take advantage of much more RAM too.
If you are a home user or are building a workstation, it may make sense to go down to the Intel Core 2 Quad Q6600. But if you have a system running processor intensive functions, the extra cache of the 9450 can come in handy. Similarly, if you do your homework you can get it for about what the 6600 will set you back.
Check it out and do your research before you decide.
Enjoy.