Some games would. Doom3 has a 512meg mode.
But it needs to be backed up with a powerful GPU.
A lorry has a lot of capacity to move things around in. But if you put a 1.2L engine in, you won't be able to shift much stuff. A smaller van with a 4L engine will probably be quicker and more efficient at shifting stuff around.
Slightly dodgy analogy, but I hope you get the meaning.