Not likely. SDRAM has very little overhead; if it's rated at DDR2-1150 you'll be lucky to get it running at DDR2-1150. I had a hard time getting 4 1GB sticks rated at DDR2-1200 to actually run at DDR2-1200. In another case I couldn't get 4 2GB sticks rated at DDR2-1066 stable at DDR2-1066 and had to fall bck to DDR2-800.
The reason for this is thus:
DDR memory (first generation) has a 2 word prefetch buffer. Each word is transferred across the IO bus on opposite ends of the IO bus clock (this is where the DDR comes from). DDR has performs 1 IO bus clock per memory module clock which results in 2 IO bus transfers per memory clock.
DDR2 memory has a 4 word prefetch buffer. Similarly, there are 2 transfers per IO bus clock which requires 2 bus clocks to transfer all 4 words. DDR2 performs 2 IO bus clocks per memory module clock which results in 4 bus transfers per memory clock.
DDR3 memory has an 8 word prefetch buffer. Similarly, there are 2 transfers per IO bus clock which requires 4 bus clocks to transfer all 8 words. DDR3 performs 4 IO bus clocks per memory module clock which results in 8 bus transfers per memory clock.
What this means is that DDR-400 / PC-3200, DDR2-800 / PC2-6400, and DDR3-1600 / PC3-12800 have 200Mhz,400Mhz, and 800Mhz IO bus reference clocks respectively and a 200Mhz core memory clock commonly.
Similarly, we can see that DDR2-1066 has a core memory clock of 266.5Mhz and DDR3-1066 has a core memory clock of 133.25
DDR2-1333 would require a core memory frequency of 333Mhz, a frequency comparable to DDR3-2666. This is extremely hard to do even on the best motherboards. As far as I know, no DDR2 based motherboards supported anything above DDR2-1200.
Intel's DDR3 controller used in the Sandybridge and Ivybridge processors is much nicer than their old DDR2 controllers but even so, the returns on high-speed SDRAM are barely noticeable.
EDIT: For clarity the core memory speed is not related to the FSB speed. They are two different metrics. Most motherboards derive the memory IO bus speed from the FSB or baseclock and the memory module speed from the IO bus speed. However, some enthusiast motherboards have separate clock generators for the FSB and the memory IO bus