Diffraction is physics. It's like asking why we can't go faster than the speed-of-light or asking why a car with a gasoline engine built for fast-acceleration/top-speed has poor gas mileage.
I look at these tests and my brain kinda fries and before I ever look I know the manufacturer's/dealer's samples will always look better than the competitors.
Still, this is just stuff to me, not real world working and maybe the next time you do this throw an old Contax into the mix.
This 100% crop was shot with a 120mm contax macro F16 and I don't think I need to ever see more detail. Actually I'm not sure if more detail would ever reproduce anyway.
[attachment=22404:contax_f16.jpg]
Then moving on to real world working, this was with the Canon 1ds3 at F 13 which I guess by your calculations of the poor old dslrs cramming too many pixels into too small a space would show defraction, noise, taco juice on the model's lips,or something awful that according to all medium format dealers, all dslrs do.
[attachment=22405:canon_f13.jpg]
Anyway, Maybe there could be more detail but I doubt if it would look more film like or give anyone anything else they want to see.
Now from the same session is real world changes. This was shot at 400 iso at F 3.5 with modeling lights. (This is just a screen shot from bridge).
[attachment=22406:canon_400iso.jpg]
Rather than rework all the lighting, put on ND's to lower the output to throw the foreground and background material out of focus, all I did was just turn off the pocket wizard, open up to 3.5, move the iso to 400 and shoot. It's tight, it's more than useable, it more than enlarges to almost any size, so back to real world, time is a premium and the ability to move this camera around is something that is hard to explain unless your on set. If I tried this with a p30+, I'd still be cloning and smoothing out noise.
And before you mention sensor plus, I just don't get 10 mpx for $20,000. If I need high iso there are Canons out there that go to a trillion iso, for $2,800 that shoot beautiful 22mpx stills, high def video, tether, have hdmi ports and live view and nobody in the professional world goes to work with just one camera anyway.
BC