Certain machine vision cameras go in this direction of the trade off since for industrial inspection they also often need more resolution and don't care that much about frame rate. I see devices listed with 5496×3672 at around 5 fps for example or even 5320×4600 at 15 fps. But they can be quite pricey.
I wonder if at a certain point, maybe 0.5 or 0.1 fps, the best approach would be to have something that takes regular photos and save them to a folder, and then something else is taking these images and produces an MJPEG stream out of it.
If the images are saved directly to the computer it could even bypass the stream/capture step entirely. Kinovea can open a folder of images with sequential names and load it as a video. I have not tested this with very large images, the explorer will be quite slow to create the thumbnails which isn't necessary for this. I think for 8K images at 0.5 fps or less this might be an interesting option.
There is also latency and lens quality to think about.