First, I do see distortion and lack of sharpness in some of the corners for some of the Flickr photos. Also without knowing the post processing workflow on the Flickr photos, it's difficult to compare images.
In your recent tests, the aspect ratios are different so the resolutions of the photos between the
Mini 2 and
Mini 4 are not the same so that is not a good comparison. You are comparing a 9MP image to a 12MP image. Also, the perspectives are different in that the MP4 was further back than the
Mini 2 which puts the MP4 at a disadvantage. The different aspect ratios probably won’t have an impact but the perspective difference can make a major difference.
The
Mini 2 has a fixed focus that basically tries to optimize the DOF based on the aperture/sensor size of that camera. The
Mini 4 Pro allows you to choose the plane of focus so it's possible to have parts of the frame out of focus. When you use autofocus of the
M4P, unless you know specifically what it is focusing on, it's possible that it could be focusing on an unintended subject. You should redo your test but place the focus point directly on the subject that you want in focus.
I am not saying that there isn't an issue with your MP4 but your test comparisons are severely flawed.