After months of troubleshooting it turns out that on Asus X870E ProArt MB and it’s siblings disabling the MediaTek WiFi in BIOS solves the problem.
TL;DR
I’ve been having random crashes following a year of stability after the 2402 BIOS update. Over the following months I have RMAed my 9950X3D after doing everything to troubleshoot and isolate the issue. No matter the memory, timings etc crashes happened about once a day on average. Weird thing is that every CPU and memory stability test always passes. RMA of the MB didn’t fix it. Literally no part of my original system remains, I even swapped the PSU for good measure.
After recent crash while searching for answers I found this post, apparently I was not alone. Hopefully this helps folks here. I have had stability after disabling the MediaTek chip in BIOS. Crazy right?