Yes, eventually. Games like Supreme Commander can reach 2 GB.
Why don't you just install the game you like and check how much memory it uses. Look in Task Manager, under Performance, at the Physical memory area. If you've only got a little still available then it's time to buy more.