First of all - thank you for taking the time to respond with so much detail and thoroughness as I know that takes a lot of time! I am grateful!!
It's very interesting that you posted this! As I was laying awake last night trying to figure this out it dawned on me about some of the battery issues we had when we bought this boat. They originally had the house deep cycle batteries wired to the main engines and the 1000amp CCA batteries wired as the house batteries. Also,the chargers were improperly wired and the generator battery wasn't even connected to a charger! But that is a whole other thread! I have a feeling these batteries were not taken care of by the previous owners the way they should have been.
Plus, I also noticed this past week that when the battery voltage was lower and the potable water pump kicked on, often times the refrigerator compressor would cycle off. Sometimes it would restart sometimes it wouldn't which ties into the other point you made about other DC loads pulling voltage down momentarily causing the cutout to be activated.
Another point is that it seems to me (only my gut feel - no quantitative analysis) that the house batteries are not holding their charge as long as they did even a few months ago. We used to be able to go on the hook for 12+ hours on battery only (before having to start the generator) and never drop to 12VDC. Now we get to 12VDC in under 8 hours. And nothing has changed that I can think of in our usage or the DC loads.
So like you said, I am becoming suspect now of my house batteries. They are only from 2020, so not that old. But if they were improperly stored/charged/discharged/etc. they very well may be near the end of their useful life.
Again, thank you so much for taking the time to post all your thoughts! Although I've worked around electricity most of my life (commercial power generation) I have a lot to learn about how it actually applies in my new world on a boat!! Especially on the 12VDC side of the house! Thanks again!!