Finally found a reddit post that had been describing exactly the same problems that I had been going through, he also gave up trying to self-diagnose and repair and he ended up taking it to a PC repair shop. His problem was that his 13900k had suffered permanent degradation which had made his system completely unstable. I remember reading about the 13 and 14 series intel chips having some serious power draw and cooling issues sometime back and unfortunately it was already after the fact I had built my rig. Guy in the OP had to RMA his chip which took 2 months but said the overall process had been smooth. So I already opened an RMA request with intel and right now it's just a waiting game.

Another user posted a temporary workaround solution that should keep my system stable enough to run normally at least until the replacement arrives. Had to download intel XTU and under-volt the P-Cores and E-Cores and reduce the fixed e-core voltage. After doing that...... drivers suddenly installing as normal. And foobar? Running crash-free on both Georgia and Georgia reborn themes ever since. I'm not sure what exactly had happened that caused the CPU to become unstable as I have never touched the bios settings, never overclocked the cpu or had done any sort of tuning whatsoever. Just updated the BIOS last night which from what I understand included an intel microcode update which addresses the voltage issues so maybe that will keep the system from crashing, for now anyways? Hopefully this is the last of my problems and I want to thank all of you for helping me.