Diffraction is absolute, and related not to FL or other lens characteristic, but simply determined by the f/number size of the aperture. Due to the fact that a small format has to enlarged by a greater magnification than a large format, the diffration simply becomes visible at the higher magnification factor which is required for the small format. Lens diffraction is always lowest at max aperture.
But other factors do enter into lens performance, and that is the ability to hold contrast at a certain f/number, and that is the MTF performance of the lens, which does vary by len design. Poor contrast at a certain f/number, in addition to lens diffraction, both combine to determine ultimate lens performance in terms of ultimate detail resolution of the lens. And that is why most lenses perform optimally about 2 EV smaller aperture than max aperture, in spite of the fact that diffraction is lowest at largest aperture.
As others have pointed out, sometimes DOF is more important than increasing visibility of diffraction at small apertures.