Hmm... I have a system running right here, in fact, I'm posting from it. Powered by a Q9650 with 4gb's of DDR2. It does everything I need it to do, from web browsing, to video watching, to Battlefield 3.
Sure, my i7 system is much faster, but, the older core2duo/quad cpu's still have plenty of...