It does make a difference with large textures, so there would be some increase as more could be loaded at once. What you end up playing depends on if it's really worth it. Playing Unreal Tournament 2004 won't show as much of a difference as with Far Cry and D00M 3 between 128MB and 256MB at the same resolution.