There are two Lightroom Settings folders. Global or Local
In Preferences you either choose to store settings locally with the catalog "(home)/Pictures/Lightroom/Master/Lightroom Settings" or Globally "(home)/Library/Application Support/Lightroom". The global location stores settings for ALL catalogs. The local location stores settings for ONLY this catalog. They are mutually exclusive depending on the settings in Preferences. Lightroom Classic only populates one of these automatically.
View attachment 30544
I understand that you are using timeMachine AND Back Blaze. IMO you do not need any other system backup. CCC is IMO redundant to timeMachine as is Backblaze. BackBlaze offers the additional security of an off-site backup destination In the event that your local systems are destroyed by some catastrophic event.
In describing your set up I see lots of (unnecessary?) redundancy. Perhaps you are overthinking the process. IMO you only need two system backups, timeMachine for a local backup, and BackBlaze for an offsite. If recovery from offsite were not so necessarily slow and tedious, then you could get by with BackBlaze only. The Lightroom Backup folder serves only one purpose, to recover a corrupt catalog. It makes no sense to store the Lightroom backup folder on the same folder as the master catalog. (which it appears that you have done). For when the disk fails, you lose both the master catalog and all backups of that catalog.
If you can recover your master catalog from an earlier state using either timeMachine or BackBlaze, you do not need the Lightroom Backup catalog process at all. I only keep these backup catalogs out of convenience because I have spare disks and it is easier to find the catalog from an earlier time in date named folders than to seek it out in timeMachine. Also timeMachine may back up the Catalog when Classic is active and potentially unstable. At some time in the past that meant a corrupt catalog on recovery, I don't think this is the case today with timeMachine but you can't be certain..
This brings me to another point. As important as it is to have a system backup, it is just as important to periodically test your recovery process. Have you actually tried to recover a random Lightroom catalog or folder to know that you can when you are not under stress and in panic mode? Once you are comfortable with your recovery process being successful, then you will not be in the place you are now.
As for EHDs, I see no reason to ever unplug them. I have a DAS that is always connected. So this is never an issue. However if I need a mobile computer, I can see where I might want to walk away deom externals. Perhaps another reason to backup to a NAS. My portable computer is an Apple Neo. It only backs up to the NAS regularly. If I travel with it, I carry a 1TB 2.5 in HDD which then gets the timeMachine backup.