This is the first real test I've seen of the A7s high ISO in still images.
http://www.photographybay.com/2014/04/10/sony-a7s-iso-comparison/
Not surprisingly, you can get away with very high ISO when you downsize the image.
But when looking at large size images, the performance looks pretty similar to other full frame cameras.
Everything looks nearly perfect up to around ISO1600-3200. 6400 looks okay... even 12800 doesn't look horrible. But above 12800, things start to turn ugly very fast in full size.
The test only goes up to 102000, which is pretty unusable unless totally downsized. (Which leaves to the imagination just how horrible 204000 and 406000 will be).
Does look better than my A99, which isn't surprising. (Larger pixels, no SLT mirror blocking light, and no loss of pixels for on sensor phase detection). It looks about one stop better than the A99. (The 25600 on the A7s looks a bit like the 12800 on the A99... The 6400 on the A7s looks like 3200 on the A99). I haven't seen enough of the A7 or A7r, but appears to only be marginally better than those two cameras.
While this camera may indeed be great in low light, it doesn't appear to be a massive technological breakthrough and low light miracle. At best, it seems like a small incremental evolutionary improvement over the last crop of full frame cameras.
Truthfully, for now, a "real" dSLR/SLT remains better for low light photography due to the availability of faster lenses (and more stabilized options as well). Unless you plan on adapting lenses for the A7s.
In low light,
A Canon 6d with a 1.2 prime lens will greatly outperform The A7s with a 1.8 or 2.8 prime lens.
A Canon 6d/Nikon d610/Sony A99 with a 24-70 2.8 lens will outperform the A7s with a 24-70 f4.
A Sony A99 with a stabilized 50/1.4 will outperform the A7s with an unstabilized 55/1.8.
The main reason to buy any of the A7 series, is really portability. Great full frame performance, very close to dSLR full frame, in a much more portable package. In exchange, you get slower native lenses. (Can apply faster lenses with an adapter but then you lose the size advantage). You get slower autofocus (though potentially more accurate). Slower burst rates. Less direct controls (a natural trade off to make the body smaller). Shorter battery life (the price of a small body and EVF).
To me, none of these trade offs are deal breakers. But likewise, a slightly smaller body isn't a major attraction to me, to lead me to the A7 series.
I suspect some day, almost all advanced cameras will be mirrorless. Western markets have been slow adopting the technology, but Western markets are no longer the only luxury consumers. Mirrorless is being rapidly adapted in the East, it's just a matter of time before it flows more to the West.
But I suspect Canon and Nikon, when they do take the dive into mirrorless more deeply, will make some dSLR-sized mirrorless cameras that work with their current lenses. Such a lineup may have less trade offs, but won't gain much portability.
Meanwhile, Sony had a small customer base of "big dSLR" users, so they have created a smaller mount system. Remains to be seen whether they will continue developing their dSLR-style mount, the A-mount.