256mb of ram is fine for just about everybody. I run 256 with my P4 2.5Gig and can run any game currently out, I also do a fair bit of photoshop and Cad work and never have a problem.
It can reap benefits having 512mb when you use really large graphics files, but in most cases it makes no difference.