Short answer No. Long answer, yes.
Under the current generation of Games, most will never come close to hitting 2GB at common resolutions (1080p).
That being said, Games which you can add EXTENSIVE mods to, skyrim for example, MIGHT use more than 2GB. Even then, i doubt it.
Where you WILL notice the extra vram is when running multiple displays in eyefinity like setups and higher resolutions.
BOTTOM LINE: If you had to choose between extra ram, or a step up in GPU, I'd go for the step up in GPU. (I'd take a 2gb 7970 orver a 3gb 7950, for example)