For maximized performance, but at a higher cost, a board with support for DualDDR will be the 'ultimate' way to go, but anyway, a DDR333 based motherboard is more than enough for this situation (e.g. i845PE), however, other features such as AGP 8x (due to the fact the i845PE doesn't support it), aren't really that much performance-enhancing.
All this depends on if your a intel or amd person.. i personally dont like intel.. i think their cpus are junk.. always crash and always seem to have the most recalls cause they waste their time on stupid commercials instead of development and testing.
DDR on a nforce board works fine if you do more than one stick of ram... they are using the nforce boards from asus alot in benchtesting.. its gotta say something for that board and the cpu maker.
DDR has had controversy, but so has AGP... depends on what you really want.