5800X3D will specifically benefit Dwarf Fortress in world generation. I don't play the game but I took note of this because it's an extreme example of the benefits of a large cache (DF portion starts at 7:27):
The IPC difference alone between a 5800X3D and Broadwell Xeon should work in favor of the consoomer part, and then it has a larger L3 cache. Each of those 8 cores can access the entire 96 MB of cache, but I'm not sure if each Xeon core can use the entire 60 MB. If there's some benefit to 24 cores vs. 8, I don't know about it.
The video also covers Factorio. Clearly, the 5800X3D is the choice for autists. But I'm guessing the E7-8894 v4 is much cheaper than its $9000 launch price.