Well the LGA775 started with the Pentium 4s, but it's not that old. It will still be used. The new quad cores will still be on LGA775.
Why would you need 8gb or even 4gb of RAM? Are you using CAD and editing software? 2GB is enough for gaming and everything else.
With water cooling, you can get the e6600 to 3.4+GHz.