With AMD Phenom II? No.
With Intel Core i7? Yes.
As for why, the Phenom II, although being compatible with DDR3, doesn't have a real performance difference DDR3 and DDR2 (I saw a benchmark about it, on a French technology Website - LePoilu knows which one
As for Core i7, there is A BIG difference between DDR2 and DDR3 mainly because it is made to work with it which the Phenom II isn't really.