Diffraction has a degrading effect on all lenses no matter what format. All well and good having a 4x5 lens that stops down to f128..while you get great DOF the results look a little better that a pinhole.
So if high quality imaging with really good depth a field calls for a camera with movements. Available in MF and LF but at the expense of lightness and portability.
My most portable MF camera is a baby graphic with a 6x9 roll film back and a reversed front standard that allows the front to tilt downward rather than upward. Works a treat and even with three lenses is way lighter than my 6x6 outfit.