I have the exact same issue and I've been pulling my hair out over this. I too can only have a working connection through tethering my phone's wifi. My partner has the same issue with his unrelated Windows 11 PC. His wifi works, his ethernet does not. We both get booted at the same time IF the ethernet somehow manages to work for maybe 30 minutes or so.
Pc keeps asking for an IP. Router does not reply.
I have done, as far as I know, literally everything to try and fix this. All the commands, registry edits, setting static IPs, different subnets, different DNS servers, policy changes, different devices, brand new hardware, had a guy from my ISP check the network, and eventually a complete reinstallation of Windows 11.
I think Microsoft has done something with an update or something and there's nothing we can do until they fix it.
Just so you know, it's not your network. It's Windows, I'm sure of it.