The first is that your working set won't fit in the processor caches and has regular cache misses into main memory -- but most of the Epyc line has 64MB of L3 cache.
Then the access pattern has to be random rather than sequential, which knocks out a major class of the applications satisfying the first criteria (all the ones that process big files in sequential order).
Then the operating system scheduler has to fail to schedule the process on a core in the same node as its data, most commonly because you have a process with more active threads than there are threads per node.
What you're left with is, basically, large databases. But large databases also benefit significantly from more cores, memory channels and I/O. Which factor dominates is going to depend on specific usage, e.g. a database with randomly accessed individual bits will be more sensitive to latency whereas one containing pictures or other medium-large blocks of data will be more sensitive to memory bandwidth.
You can certainly find a worst-case usage pattern for one or the other but in general they're going to counterbalance each other.
Most working sets fit in even 8MB (or less) -- the reason for 64MB is to provide for multiple threads. In which case if one thread isn't using its proportionate share there are seven others that can use it. Sharing with sixty-three instead would be "better" but at some point it's diminishing returns.
I think you know that "total disaster" is pretty much hyperbole.
I assert that AMD is competitive [1] [2] and is definitely cutting into Intel sales [3] [4]. Even Intel's CEO thinks so [5].
Care to back up your claims with well known, respected, repeatable benchmarks?
[1] https://www.anandtech.com/show/11544/intel-skylake-ep-vs-amd...
[2] https://www.anandtech.com/show/12084/epyc-benchmarks-by-inte...
[3] https://www.forbes.com/sites/patrickmoorhead/2018/06/20/how-...
[4] https://www.fool.com/investing/2018/05/29/amd-keeps-chipping...
[5] https://www.cnbc.com/2018/06/11/amd-will-create-stiff-compet...
Even Greg-KH warns about Intel's performance due to these exploits: http://www.eweek.com/security/linux-kernel-developer-critici...
Ex-CEO.