Typical, the second I post this, I figure out what the issue is haha! (At least it seems to of been the issue).
I'll describe what I did to fix it here, in case anyone else is having a similar issue. TLDR: Asus bios setting "Legacy USB Support = Enabled" fixed it for me.
In the Asus Bios > advanced menu > under the USB section, there is an option for turning on/off the legacy USB support (for non EFI devices - I believe such as the TT PSU I have). Now usually by default this is set to "Auto", and what this setting does is disable legacy USB support if it can't detect any legacy USB devices connected. This causes some issues and seems to make it temperamental as to if the PSU gets detected or not (I think it detects it until something stops it, then it can no longer detect it at all). If it's set to disabled it will 100% not get detected, but if turned to ENABLED, then it seems to be recognised and work as intended. (assuming it's just not a coincidence that I changed this just now and it worked, I will report back if it stops working again at some point - but as of now it fixed the issue).