There is zero benefit from installing DDR2 800MHZ memory in a 667MHZ Core 2 Duo MacBook Pro or any of them for that matter...
Further - the JEDEC spec 800MHz program does NOT operate correctly in a Core 2 Duo Mac that takes the 667MHz memory.
We are now offering the 800MHZ memory for the new iMacs and had concern when we went ahead to test that backwards compatibility. This is the case with both Hynix and Samsung original 800MHz 1GB modules that came in new iMacs we've got in testing now too.
If you've got a 667MHz Macbook, MacBook Pro, iMac, or Mac mini - get 667MHz spec memory.
FWIW - the Mac Pro is a different situation. There is no benefit for 800MHZ FB-DIMMs in the 667MHz spec Mac Pro models- but the 800MHZ FB-DIMMS fully backwards compatible operate at 667MHz C5 when installed into the 667MHz systems - for those looking for possible future flexibility.
And even that said... in our experience - over 90% who buy memory for that upward mobility never take advantage of that. Either because when they do make their next upgrade, another different type is now needed or because it's just as well to keep the existing machine (or sell it as is) with the performance benefit the extra memory gives and just get new memory for the new system... especially right now with prices so low.
My advise - save the difference and get the product that's spec for your system. Time value of money and all that stuff.