I'd say no for the moment. It is great performance, but it is too (unjustifiably) expensive. 4-8Gb of DDR2 PC2-6400/PC2-8500+ is more than adequate for just about anything and everything nowadays. Whereas DDR3 will no doubt be 'teh future!', I'm not quite sure that the industry is ready for a mass-rollout of it right now. Too expensive to manufacture, and games/applications just won't utilize it all... yet.
That being said, GDDR3 on graphics cards is a must-have .
If you're thinking ahead, just get a DD3/DDR2 compliant motherboard and then upgrade in time when the prices come down to meet the needs of the consumer.
libertarian benefit collector - anti-academic super-intellectual.
http://mixlr.com/the-little-phrase/