that is a good question. although for home use, any cpu bought today would be fine. unless you do some demanding photo shop and multi tasking, there really is no reason to go dual core, unless you want a great deal of power for the future games that utilize that dual core.
intel socket LGA775 is used for dual core, so that really isnt a problem upgrading.
amd on the otherhand is going to be making a new socket soon, so i cant help you there.
also posted by you
"dual core graphics"
i dont know of any, please share your info if you do, i only know sli.
hope this helps
konny
Over the years, I have done some upgrading and component work on various computers. I am currently looking to build a system. In the past, Intel and AMD have been competing for core speed with various processors, then shifted to their respective "extreme" versions. Up until now, you could work within the confines of what motherboard could be upgraded to a faster processor, if you didn't need the top speeds right away. Lets face it, it was all single core, and understandable.
Now I am putting together, what is probably a very average machine. One that would be used for home, family and maybe small business use. I don't currently need extreme speed. But, on the other hand, I want this to still be upgradable in the future.
Now comes the dilema. The only thing you see now is dual core processors, and dual core graphics. Do I have to now start rethinking my MB choices to allow for dual core,just because that is the only expansion that will be available in the future? Any thoughts?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic