> I suspect in-camera processing though is a bit of a dead end for pro and prosumer cameras because your laptop/desktop is going to be able to do a much better job, and your camera just isn't going to have a good workflow for post-processing and organizing photos.
Something like Night Sight as a post-processing method might not be practical. You need many short exposures instead of one long exposure. So basically, you've got full-resolution raw video to deal with instead of a single shot. More efficient to process that before storing it and transferring it.
Based off of how cameras are currently used (at least from my limited sample size), I don't think that would really matter.
People regularly shoot in various "raw" formats which are significantly larger in size so that they have more flexibility in how to post-process. They capture a whole bunch of extra data, move it around, and generally store it indefinitely knowing they will throw a lot of it away in the final photo so that they can make the decision what to throw away later while they're looking at a 27" colour-corrected screen instead of a small camera screen.
People don't do HDR on-camera, they generally shoot multiple exposures and adjust in software after to get the effect and balance they're looking for which is basically Night Sight to a lesser degree.
A bit of extra disk space and transfer time is small peanuts and already fits the workflow most photographers are used to.
Something like Night Sight as a post-processing method might not be practical. You need many short exposures instead of one long exposure. So basically, you've got full-resolution raw video to deal with instead of a single shot. More efficient to process that before storing it and transferring it.