I've posted this before but posting here in the hope others might benefit from it.
I was having issues with crashes in multiple games but rdr2 was the worst. I had a rig built with an i9 14900k and Asus hero z790.
I finally found the solution and it was to do with the default bios settings for my Asus MB and my i9 14900k.
In the document linked here...
Page 98, Table 17, Row 3: Reveals the stock turbo power limits for the 13900K and 14900K CPUs are 253W, not the 4,000+ my MB's Bios settings default to. Page 184, Table 77, Row 6: Lists the maximum current limit at 307A, far below the MB's default of 500+A.
I found this information in a Reddit post (https://www.reddit.com/r/overclocking/comments/1axepvu/optimizing_stability_for_intel_13900k_and_14900k/) and followed the settings as follows:
ASUS Z790 Motherboards:
Save your current settings into a profile so you can return to them later if you want.
Reset your BIOS to default settings. Ai Tweaker tab:
Disable MultiCore Enhancement.
Enable XMP(if your RAM supports it).
Set SVID behavior to Typical Scenario.
Set short duration turbo power = 253
Set long duration turbo power = 253
Set max core/cache current = 307Amps
Doing this immediately stabilised the CPU temps as well as bring down the average temp by ~10 to 15c. It's been a few months now with zero crashes.
Hope this helps someone
Totally worth celebrating. Well done!