Of note is the single review that I've seen test this theory in BF3 and shows it to be a faulty theory. The 7970 has more memory, but the same settings consume much, much more memory (and this was at much, much higher resolution). The review is in multi-gpu configurations, but that shouldn't change much here.
http://www.hardocp.com/article/2012/03/28/nvidia_kepler_geforce_gtx_680_sli_video_card_review/5
Fezerp, I agree with your principle that getting more than 2gb is not worth it. 2gb 680 is a better buy for sure. You can easily pass 2gb in certain games with high AA levels, but there are very few games where this is applicable. Remember, presentation stuff takes VERY LITTLE vram but
MSAA eats it up like no tomorrow.
The first thing to know about bf3 is that it dynamically changes LOD depending on available VRAM. So you're not really understanding how frostbite 2 works. If you have more VRAM, it will take advantage of it-- So if you have 3-4gb of VRAM, slight gain in LOD. If you have 2gb, thats fine too, no performance hit but less LOD. This was discussed by a DICE developer at last years geforce LAN, youtube it if you doubt this.
Crysis 2 with HD textures modded and DX11 tessellation passes 2gb of VRAM at 1600p if you are using ULTRA detail, as does metro 2033 with all of the bells and whistles enabled at 1600p. Dont' believe it? Run the games with MSI afterburner overlay at 1600p with those test conditions. Furthermore, many DX11 games where you want to enable SGSSAA can also surpass 2gb of VRAM, in some cases 4-8X MSAA will also do the same thing, but there's VERY VERY few titles where this is applicable. If you doubt this, run MSI AFTERBURNER overlay with memory usage showing at a 1600p resolution. Its black and white, i've been toying with a 4gb 680 recently and it definitely does pass 2gb in a few games.
Again - I agree with your principle --
getting more than 2gb isn't worth it. But you're wrong in your assertion that you can never pass 2gb, that just isn't true. Its just rare and limited to a few titles that not many people play anymore, and its also conditional based on the level of AA you're using. There is also a large variation in VRAM usage among different games. I just played SR3 at 1600p with 8X MSAA and VRAM usage was around 1.25gb. Crysis 2 however, was right at 2.4gb. Crysis 2, metro 2033, skyrim modded to hell and back with high levels of MSAA to name a few are games that can potentially pass 2gb in the right test conditions.. But you have to be at a high resolution 1440p+ or surround with high AA levels to bring this to light. For the average cretin at 1080p it doesn't make a difference.