There is NO ideal apterure for a DSLR that translates to all lenses. Your previous post made it sound as if there WAS such an f/stop. I have been a professional architectural photographer for 35 years. Each lens needs to be tested. Most WILL end up with the greatest detail being just under where diffraction starts to appear, but not all.
Rather than encouraging someone to just use f/7.1 as their go-to best aperture on a DSLR, why not encourage them to explore their own gear with a series of simple tests that will be tailored exactly to their lenses?
I will say this one more time - I have a lens for a full frame DSLR (Canon 5Ds is what I use it on) and it is far superior at f/11 than it is at f/8 and f/16. I have owned 4 of these lenses in fact. They have ALL found their best performance at f/11. I know someone who is perhaps one of the best architectural shooters in the world who I told about this lens. He bought one, tested it and... surprise surprise, he reports the sweet spot at a very obvious f/11 too.
Test your gear people. It is not as simple as you think it is. But it's not hard to find out the truth with just a few minutes of your time.
Yes, there is variations in lenses and that can skew the preferred setting up or down a bit, but diffraction limiting is NOT a function of the lens and is entirely down to Physics and no matter how brilliant the lens maker is and how beautifully the lens is made the diffraction issue is always there. For landscape and other non-drone photography you sometimes want to limit the DOF so it's advised to use a lower f/# and at other times you can't help but include nearby and distant features that you want decently sharp so for that situation you can easily go well above f/16. You will lose some sharpness when stopped down like that, but as others have said you do not always want the image to be super sharp.
But, drones change the picture in a couple ways: first, the sensors are smaller so the f/# you need to use to get comparable sharpness tends to be lower and as I mentioned with the GoPro type cameras with fixed aperture at about f/2.8 they still get decently sharp images and DOF owing to the small sensor size. Additionally, we tend to have less near-ground objects as we tend to fly a 100 or so feet above the ground thereby limiting the presence of close objects and we can therefore run with a lower f/# and still have things sharp.
I have not demanded everyone follow my guidelines as my posts were just that -- guidelines, a place to start. With smaller sensors it's not so easy to get background blurring due to the two facts of being, generally, further away from the close objects; and secondly, the sensors being smaller tend to produce a greater DOF at the same f/#.
Lastly, if you have a full frame DSLR lens that is sharper at f/11 than f/8 then I can say with absolute certainty that you are either mistaken or the lens isn't all that great! Most lenses are sharpest a stop or two down from wide open so an f/1.4 lens would typically be sharpest around f/4ish. Of course, that's before you take into account the diffraction issue which is not related to lens quality or construction. My best lens for sharpness, the Zeiss Distagon 21mm that I use on my Nikon D800E's, is sharp center to edge and I get the greatest detail right at f/7.1. The lens is sharpest around f/5 but stopping down a bit increases DOF. Beyond f/7.1 the efffects of diffraction, which are present even at f/4, begins to overwhelm the DOF improvements with smaller aperture so the detail tens to diminish.
For the P4P with the much smaller sensor than my D800E's the aperture where max image detail occurs tends to be more like f/5 or f/5.6 but can be as low as f/4. For my D800E's I get max detail around f/5.6 to f/8 with some small variation in lenses but more as a result of different scenes.
Brian