I finally found the problem! After reading this article it dawned on me. The author describes the exact problem I have in my home network. Amazingly, by solving this seemingly unimportant issue, I found the key to another -- 6 year long nagging and utterly frustrating -- WiFi issue I have in our home.
Here is how it works:
- When a Mac is booted or wakes up from sleep, if WiFi is on, it scans for available network SSID's
- The first SSID it encounters emits beacons containing its country code
- The MacBook (mobile devices can travel to other countries) conforms to the country code of the router (routers generally don't travel)
- According to the country code settings some channels may or may not be available
- In our home we have an Omnik solar inverter, the WiFi of which is established by setting up an AP by the Omnik itself which in turn connects to the router after configuring the right settings
- The Omnik WiFi module is set to country code TW (Taiwan) and emits beacons at 2.4GHz
- When our MacBooks wake up from sleep, scan and find the Omnik first, the CC will be set to TW and 36 40 44 48 channels are dropped
You can check the screen shot in my OP, CC is TW. Thank you for providing the links above, I found that only the macOS built in Wireless Diagnostics tool will actually display the country code, so this was very helpful!
I recently went 5GHz only in my home network. 5GHz signals carry less far than 2.4GHz so the Omnik now wins lots of times and then macbooks fail to reconnect.
Mystery solved!
Now trying to contemplate a solution approach...