Adding more VRAM won't improve performance by a single frame in any of the tests we ran.
Quite bold statement there for a reviewer, w/o actual test in-hand to prove the point.
Fact is, maybe not, but with a slightly higher resolution, and/or perhaps with other (or coming-soon) games, it will. I'm bumping up against the 2GB limit in Far Cry 4 on my GTX670 now, and that's at 1080p. Mem Usage per Afterburner remains pegged at just under 2GB at all times, and the stutter at times (esp when flying in the copter or on ziplines) is blatant ... no DOUBT in my mind ... vram is the issue.
And I'm sure it's not the only game in existence where that would happen, but even if it is, it's just a matter of time before there's more.
Hence, something that really should have been mentioned in your review, IMHO, when talking about the option of the 970 ... is the VRAM capacity. In that case (vs 960 SLI), you pay LESS, you get nearly the same performance, you have zero SLI hassles ... AND you have A FAR better upgrade path available to you (SLI 970's) should you choose it ... say if one decides to grab a 4K monitor, for example.
With the 960 SLI setup, you're stuck at 2GB. The 970 offers double the memory buffer, and an actual viable upgrade path. A lot to be said for that, IMHO.
And AFAIC (as you correctly noted overall), a 960 SLI setup makes basically ZERO sense.
Now, given the gaping price point between the 960 and 970, however ... I can imagine that we'll be seeing something like a 965Ti coming along within the next 4 months or so. Imagine a $250-275 price point Maxwell card, with an extra processing cluster enabled with 3GB gddr5, 196-bit Bus (so as to sit right between the 960 and 970 in terms of cores, Mem Cap, TMU and ROP), and with Maxwell's great OC potential and power consumption and new features?
Yeah ... when THAT card comes out ... that baby is gonna be the 'sweet spot', esp in SLI. THAT setup would crush a 980. And that's the kind of thing we really want from the 'x60' series card from nV ... two of them crushes the flagship, for just a little more dough. It's what we 'expect'.
This 960, however ... it's ... almost painfully mediocre in every regard save power/heat/noise.