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.
Large databases and complex queries or video streaming definitely will benefit from higher clock speeds from single core performance. But if you plan for multiple users using your services at the same time, then multicore benefits will outweigh single core performance.
So if you are the only user than single core it is, but if you have multiple users or run multiple docker containers than you reach a bottleneck quite fast, where background services will compete with each other.