thoughts about car battery keep hooked up OR disconnect ?

Some things can happen leaving a battery connected. Years ago my daily driver Mopar's horn started blaring in the middle of the night all by itself. If I were not home what would the possibilities have been? Dead battery, over heated circuits resulting in ????.
It seems that battery terminal corrosion is worse with a connected battery. I have a quick connect cable end on my a-body which is also not driven much. All it takes is to pop the hood and disconnect, no tools needed.
Have also heard of a collector who had battery tenders hooked up to several vehicles that were unattended for periods of time. Evidently some malfunction caused a few batteries to explode. By the time they were checked the acid had done considerable damage. (Just something I heard, don't know if true).
Yote