I am guessing that while Nikon is producing cameras, the sensors themselves are produced by Sony. It appears that both the new Pentax that scored so well uses a Sony sensor as well which would explain why the Sony, Pentax and Nikon versions all scored about the same. In any case the sensors are far more capable than most photographers.
Bill
Nikon apparently use Sony based sensors but modified or tweaked to Nikon specs. Supposedly, though no one really knows, newer Nikon sensors are more and more Nikon designs etc.
This would explain much of the improved ISO performance of Nikon over Sony.
I agree that these sensors are extremely capable, and then one can really get into discussions as we always do about it being about the photographer not the camera etc.
But that is all beside the point, otherwise we all would have stopped buying new cameras a few iterations ago. Compositionally etc, I don't take better or worse images with my daughters D40 than I do with my D700 or D7000. On the other hand, the capabilities of the D700 and D7000 allow me to take photographs in some situations that the D40 simply can't get at all or if it can the quality will be inferior - including low light, better dynamic range - again very noticeable in low light and contrasty lighting, rapid frame rate like when I was on shooting Great Whites breaching, larger enlargements, better range of bracketing for HDR, much, much faster focusing for action, now of course video, and the list goes on.
Camera sensor quality will definitely not affect the composition of an image, but can make a huge difference in the quality of the final image. As both Canon, Nikon and others have pushed the quality of their sensors, it's absolutely created new photographic options.
Broadly speaking there are 3 things I pay attention to, megapixels (for enlargement potential) , high ISO ability, and dynamic range. Improvements in any of these create opportunities to capture better quality images in the technical sense than we previously could. With the size of enlargements I do, anything above 12 MP is adequate. High ISO has completely changed how I shoot, and even what I shoot, and dynamic range of all cameras still falls short of what our eyes see and frustrates me at times when I have an image of a sunset or something that does not do the real thing full justice. As monitors improve dynamic range differences will be more noticeable. So I still think a one stop improvement in dynamic range of the D7000 over the 7D is significant , others might think the extra 2MP of the Canon is more important, I have no problem with that. For others the Canon's better video is more important, also OK. For me video is way down the list, mostly because I totally suck at shooting video. Astrophysics, sure, if that's what you need, buy Canon.
As Drew has said many times, cameras are tools, every one should choose a camera according to what best suits his shooting needs.