Thanks for the tips so far. I was afraid ethernet protectors/arrestors were like some common thing everyone knows about and assumes we are all using, but never talk about. My battery backups have built-in 1GbE ports for supposed protection but not sure if those would really do anything (not currently using them).
After doing additional testing there is definitely something screwy going on. All of my devices are on various APC 1500VA UPS’s with the oldest no more than 5 years old. Also just did all the firmwares and hard power cycles on the switch & router to rule that out. Like mentioned the PC and other wired devices connected to the switch seem normal. Based on how the USB adapter is also still working fine I’m guessing some 10GbE thunderbolt adapters may be in my future.
Here are the hardware components in the wired network chain:
-Fiber modem
-Asus Rapture GT-AXE16000
-Zyxel XS1930-10
-Desktop PC
-few other IOT ethernet things
-Mac Studio
-Mac Mini
The fiber modem is in the same room as the Studio, and goes out a keystone, across the attic over to a keystone in a different room to the router. The switch then connects to the router, and from the switch another run comes back over the same route (different keystones/cable) to connect to the Studio. The Mini just has a cable from the switch running loose along the floor to a third room.
My totally scientific test results:
Mac Studio, plugged into built-in 10GbE port
-Connected to switch: macOS can see there is ethernet hardware now (before it was completely gone), but does not recognize a cable plugged in. Lights on switch show no connection. Also tried booting into an older macOS partition with same result.
-Connected to router: same thing, router dashboard shows no connection.
-Connected to fiber modem: same thing.
Mac Studio, plugged into 1GbE USB-C ethernet adapter
-Connected to switch: works no problem
-Connected to router: works no problem
-Connected to fiber modem: works no problem
Mac Mini, plugged into built-in 10GbE port
-Connected to switch: the switch has the blue 10GbE connection light. The Mac mini shows under hardware info it has a 5GbE connection instead of the usual 10. It can’t get an IP address and self-assigns.
-Connected to router: connects and works no problem, but still limited to 5GbE.
Mac Mini, plugged into 1GbE USB-C ethernet adapter
-Connected to switch: works no problem
-Connected to router: works no problem