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.
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.