This may be naive but I am unsure how you tell what applications benefit most from single core performance vs multi core performance. I feel like upgrading my server to a processor with higher single core performance will benefit the “snappiness” because the CPU utilization percentage sits at such a low level. But that may not even make sense.
Usually “a server” runs a lot of different things and programs. Multicore is especially beneficial in that scenario because even if a certain program does not support multicore processing, the os will just run “the other app” on another core.
So the concept of which app can use multicore processing is mainly relevant for desktop PC’s that run “one big app”.