Back in the day with the PIII i820 and i840 chipsets, a converter could be plugged in for SDRAM to be used, though it did take a toll on system performance.
If you want a P4 processor with hyperthreading, RDRAM is the way to go (though unfortunately, the i850x chipset does not support 800 MHz FSB processors). Dual channel DDR still works just as well, however, if not better.
Due to its high latency, I myself don't see any point anymore in using Rambus in home machines - Creative Labs tried fitting Rambus on their 3D Blaster graphics card (Cirrus Logic CL-GD5464) in the past and it failed to say the least.