Basically... my goal is to create an $800 computer that will preform decently for a few years. little gaming, I don't need anything like 60fps on F.E.A.R with high settings. I will probably do a little overclocking as well... nothing major.
I would also like it to be upgradable if possible.
So far the only thing I know I want is a E6300 Core 2 Duo. I am looking at a GIGABYTE 965P-DS3 motherboard right now, but that could change as well.
I would recommend a GIGABYTE 965P-S3. It will save you $20 that can be added to RAM or a better video card. Or go with Media Centre 2005 w/ Vista upgrade OEM (free to home prem, except $20 in random stuff).
How much you want to overclock? Here is a little chart with some info for you.
Intel Core 2 Duo E6300 - 1.86ghz at stock - 266*7, 1860mhz, 1066FSB. (DDR2-533 memory for pure-stock) ($100/gigabyte of RAM)
What you could do... boost that to 333*7, 2331mhz, 1333FSB. (DDR2-667 for this small overclock) ($105/gigabyte of RAM)
Or... boost that to 400*7, 2800mhz, 1600FSB. (DDR2-800 for this good overclock.) ($115/gigabyte of RAM)
Or... boost that to 450*7, 3199mhz, 1800FSB. (DDR2-900, nonstandard, for this high overclock.) ($130/gigabyte of RAM)