You say "buying a new computer". Does that mean you're buying new parts to build a new computer? I assume it does, since you're fishing for RAM modules.
I didn't consider over-clocking until around October, 2003. At that point, I was building a X-mas gift for my sister-in-law, financed by my bro'. For her system, I didn't want the cheapest RAM, nor the most expensive, and I settled on a Corsair 1 GB kit that was supposed to be reliable at DDR400 with latencies of 2, 3, 3, 6, although it booted from the SPD settings as PC2700. There was a problem with it, and Corsair turned around a replacement pair in a matter of three days.
Then I started planning my "MOJO". I might have got a pair of value-rams, or some Kingstons, but THG had posted this article on OCZ DDR500 modules and it matched my other choice of hardware. Maybe I could've run this system with the OCZ DDR400 Platinum revision 2's people speak of here, but I'm very happy with these EL Gold modules. This was where I intended to spend some money strategically, anyway.
If you're not too sure about future over-clocking, follow the advice of earlier posts. You may be able to get some great over-clock settings with moderately priced modules, and I would still suggest you find some with low latency SPD defaults. Barring the uncertainties of getting stable 1:1 results at higher FSB settings, at least the low-latency DDR400's will get you better performance. These days, you should be able to find some Mushkin DDR400 or DDR433's that will run at 2, 2, 2, 5.