@Nikkolai Davenport Thanks for the links, I'll give them a deep dive later today. First let me say that I'm a fan of Dr. Glover's efforts. I've watched both of the video presentations you linked and examined his sensor analysis tool in Sharpcap and it's great stuff. It's technically sound and is a fantastic resource. It enables users to come up with an exposure that will consistently deliver good results across a mix of equipment and sky gradients. It also allows users to get the most out of their equipment. So my comments are not to be taken as criticism of the analysis and results. My sole point was that the terminology of optimum exposure could be improved.
I did skim through the summary at the end in the lengthy thread and noticed that the takeaway is the same as in the video - That a 5% noise target gives a very good exposure duration that gets the user to the stable (less noisy) part of the SNR curve. He does go on to show that there are improvements beyond that point. My point is that since going beyond that point yields improvements then calling the noisier, shorter, exposure "optimum" is confusing. Since the user is in effect choosing their acceptable noise level (5%) then calling it minimum acceptable is arguably a better term. Optimum to me means that it works like say the electrical timing in a car engine - going below this number has disadvantages as does going above this number. But here optimum gives good results but going longer gives better results (even if the better results are small and diminishing).
It's also important to recognize that as Dr. Glover also mentions that this analysis is targeted towards the dark part of an image that is noise limited. Shot noise and read noise are much less important in the bright part of an image such as we find with stars, here the noise is in the noise lol. Since stars can be processed separately courtesy of new tools like Starnet and StarXterminator they can be acquired separately and the analysis is different. Here maximizing dynamic range is key. Similarly, as Dr. Glover mentioned, with NB imaging long exposures are still needed and with say 3nm filters, the upper exposure limit will typically be lower than the "optimal exposure limit".
Having said all of that -
re: "As I see it, the problem with making saturation of the background the upper limit for an "acceptable exposure" time is that by that time you have long oversaturated the brightest parts of your image".
Well not exactly because I suggested ignoring stars since these can be processed separately and then stopping before saturation of any of the diffuse stuff.
re: "It seems there's little point in exposing longer than the "optimal exposure" than is convenient".
I don't disagree. But in his hobby we often see examples where folks go to great lengths to get the best possible image of an object. Including multi-year 40+ hr long exposures. I wouldn't say that those who go overkill are necessarily wrong in doing so.