Yes it's possible. No it won't be easy. It will require some trial and error and some commitment. The cooler that bolts in is the D9729. It cooled the old 130W PentiumDs and 3,8GHz Pentium 4s. The better cooler is T9303. the heatpipes are in a different place. if you buy it with the cover you can cut the top1/2" off and put it on your old cover. Or just move the holes.AFC1512DG is a fan upgrade. it replaces the whole fan and holder assy. Velcro and Duct tape will make it work. Throw some heatsinks on the VRM MOSFETs while your at it.
The 780 MB is rated for 95W CPUs and won't boot anything higher. "Q9550s". "Q9505s","Q9400s" are 65W quads. This gets you some headroom to overclock. No C2X chips will boot so there goes quick and "easy".
Your PLL chip is CV184-2APAG it's an IDT chip. Write that down.
The first technique is SetFSB overclocking. You can do a little bit without increasing voltage just to learn to use it . You will need your PLL# for that. Clockgen is another similar program. A $10 donation will buy some tech support. I've seen reports of Q9550s going 3.8GHz on stock Voltage.
To go higher you will need more Voltage." VID pinmod" or Padmodding is the technique. This will require some research and study. There are pins on the CPU that can control Voltage if you send either a high, or low signal to them using metal foil, or insulating paint. You can find images of the setting for various voltages online. It helps to know what Voltage you already have so you can pick a setting the requires only one change. Since very few people have overclocked the 65W CPUs you'll have to find your own settings. But they do overclock very well. You can use your Q8400 to learn on if you want to.
The Q6600, and Q6700 you mentioned are already 95W CPUs. If you tape mod the Q6600 from 266 FSB to 333 fsb you will get 3Ghz. same as Q9650 with smaller cache. the Q6700 will go to 3.33Ghz but will be drawing about 120W at that speed so you will need a Voltmod anyway.