After many hours of searching for a solution I stumbled upon this thread. I was running an Asus x670e Extreme Mobo and returned it because the internet kept dropping on heavy loads. Like most people already said, when you are downloading big files (for me it was big games from steam) the internet will just drop and would only come back online if I unplug/plug the ethernet cable back. So I thought the issue was the Mobo, therefore, I went ahead and ordered an Asus x670e Pro-Art Creator Mobo (which has the same 10Gb Port in question) and I experienced the same issue while downloading games from Steam and Xbox PC Game Pass. I have since disabled the IPv4 and IPv6 settings as other users indicated and that seems to have fixed the issue (for now). What baffles me the most is that this issue has been happening for months and Asus somehow is unable to reproduce it, yet I was able to reproduce it easily with two completely different mobos.
I even bought an intel x550T2 server network PCIe card with two 10Gb ports to test it out, and I never experienced any connection drops there. However, after spending $500 on my latest mobo, I shouldn't have to buy a separate network card and use one of my PCIe slots or do any work arounds to get the onboard 10gb port working.
PC specs:
CPU: AMD 7950x (with PBO enabled)
RAM: Corsair 32GB Dominator @6000MHz
PSU: Evga P2 1200W
Mobo: Asus x670e Pro-Art Creator-Wifi
Driver for the 10gb Port: 3.1.6.0
BIOS: 0705
Network:
Router: Ubiquiti Dream Machine Pro
Switch: Ubiquiti x24G Enterprise (10Gb ports)
ISP: Comcast (XFinity)
Bandwidth: 6 Gigs Up/Down