Oh, installing MoKiChU's driver pack was my best hope to resolve your issue. I'm now wondering if your motherboard has a fault. Maybe speak to Asus support and see if you can get it exchanged? Hopefully there is way to get it working before that, but I can't think of what to try next 😞
Very strange that it does work sometimes.
Z690 Hero, BIOS 2305, ME Firmware 22.214.171.1246, 7000X Case, RM1000x PSU, i9 12900K, ASUS TUF OC 3090TI, 2 x 16GB Corsair RAM @ 5200MHz, Windows 11 Pro 22H2, Corsair H150i Elite AIO, 4x Corsair RGB fans, 3x M.2 NVME drives, 2x SATA SSDs, 2x SATA HDs.