As above, in order to keep the same shutter speed at f11, we'll have pump the ISO up to 1600. Will ISO 1600 on a FF look the same as ISO 500 on a crop camera? I'm not sure.
f11 sounds very limiting to me, although I'm very far from buying RF lenses anyway.
I just set up the experiment in the garden with the 80D and EF-S 55-250mm 4.0-5.6 IS STM:
Take 4 pictures from the same spot, over a quick period of time under a clear sun. So the perspective is identical and the lighting conditions are identical.
Same shutter speed in all of them, so that they all can be magnified to the same extent because they all have the same motion blur.
2 images are taken at 100mm and enlarged by a factor of 2 horizontally and vertically. 2 are taken at 200mm and not enlarged. So the FoV is basically identical.
For both focal lenghts, one image was taken at f/5.6 and ISO 2000 and one at f/11 and ISO 8000. So they all have the same brightness.
They are all taken at the same whitebalance and focussed on the same flower.
There are not adjustments to the brightness or anything else in lightroom. No sharpnes, no profiles. Turned down all the chroma and luminance noise reduction. The following comparison shows only the center 1920 X 1080 section of each image (after enlargement of the 100mm ones), so that differences are more apparent. There is a bit of uncorrected vignette in the wide open shots that may appear to impact brightness.
My expectation and understanding of the subject: Enlarging / Cropping by a factor of 2 has a comparable effect on image noise as decreasing the aperture by 2 stops.
The results:
To me it looks like the bottom right looks best, the top left looks worst and the two others look close enough for me to call that equivalent. Obviously, one is a bit softer due to being a 6 MP section of an image that is upscaled to 24 MP (factor of 2 horizontally and vertically). But so far I stand by my original point: If I can get images that I like with my 150-600mm C at 600mm f/7.1 (And 500mm f/7.1 for that matter, to use the exact equivalent), I don't agree with the assesment that 800mm f/11 is a useless lens for the same applications as it should deliver very comparable images. Nonetheless, I totally agree with you that a prime with f/11 is very much a lens with a narrow range of applications and I personally would only consider it if the price or weight are outstandingly low.
Here is a variation of the same comparison, where the diagonally opposing image is set beside each one for a better look:
Should the upload have messed up the files (Edit: It did, these were originally 4K images. You can still see the differences though) and somebody doubts my assessment, maybe conduct the experiment yourself. Or make a suggestion where I can upload the files elsewhere for acces to a better quality version. If you see an issue with this demonstration, please let me know.
Please do not see this as me trying to be right. I'm just trying to confirm and demonstrate what I'm saying here so that we don't need to argue endlessly. Far more than 1000 words have surely been said about the subject, and I think images add more than written back and forth.