When I edit images (some drawings and photos), I can use almost 512MB easily. But memory usage doesn't always stay up there.
Basically, the answer I have to give is that if you already have 256MB of RAM, and have to ask to see if you need more, you probably aren't doing anything that will come close to stressing 1GB.
Same current games will, but there aren't any games that are worth playing in that range