There's now a second page to the existing diffraction tutorial. The new page is located at:
Understanding Diffraction, Part 2: Resolution, Color & Micro-Contrast
It's reasonably technical, but aims to address why there's so many different opinions on when diffraction will become visible with a given sensor size/resolution and f-stop. The article incorporates issues relating to Bayer sensors, the color content of an image, extinction vs artifact-free resolution, etc.
It also provides a new calculator that can be played with to see how f-stop affects image properties for different sensor sizes and megapixel counts. As always, actual results will depend on the particular lens, but overall I think you'll find that it agrees pretty well with how images tend to appear.
Finally, please forgive the slight redundancy with the earlier tutorial; this is only there so that the page can stand on it's own if needed.
As usual, any comments/feedback/critiques/etc are all appreciated.