Maximum PC did some benchmarks with XP and increasing amounts of ram for different applications.
Basically if you are doing photo, video, or audio editing with very large files, going from 256 to 512 helps with rendering time.
It had no effect in their Quake 3 demo test.
512 is worth it depending on the apps you use.