Same issue with a gigabyte z690 UD DDR4 motherboard and realtek 2.5Gb ethernet.
Approximately each 24 hours when I turn on my PC i have link up but no valid IP (only ip in 169, default ip when no dhcp). I I thought it was my DHCP server but no, each other computer get IP address.
With wireshark i can see traffic on network.
i have try a lot of things like reinstall windows, change drivers, change switch, change DHCP server.
I have found a workaround, i turn off my switch, wait 15s and turn on my switch. Windows detect link down/up and network is back.
For the moment i downgrade to 23h2, waiting for a real patch from MS.