I would have agreed with mostly everything you just said a while back, but after jumpin down the rabbit hole with Iliah Borg and others involved in raw conversion, I'm beginning to understand choosing the right raw converter, exposing for that converter, the nuances in the ways these cameras are built...and the nuance and dependability of reviews/tests, and that includes DXO mark.
When I say sweet spot, I'm referring to the point where it becomes more advantageous to boost in raw devoloper rather than boost ISO in camera. This rarely correlates to extended camera ISOs. With the A900, that number is between ISO 100-400, depending on the converter used (maybe higher with Adobe, as it's about the worst out there.) That number goes a stop higher to ISO 800 with the D3x. I don't know what that number is on your Canons, but I can almost guarantee it's not what you think it is, given what you've been saying.
Saying that the A900 is a single ISO camera is absurd, unless you shoot in the way I mentioned above, in which all cameras are essentially single iso cameras. If using in camera ISOs, the A900 does fine in the noise department compared to the competition until iso1600, where it starts losing noticeable ground. Of course, it also has distinct advantages over other cameras at ISOs lower than 1600. The issue that some are having with the 5dii is that's a jack of all trades, master of none. If shooting in the lower ISOs, the D3d and A900 reign supreme, with each having advantages over the other depending on the scene. At the higher ISOs, the D3/700 is still king.