The most important piece in order to get good performance in HoN is the single-core performance of your processor(CPU). You'll therefor want a modern CPU with a powerful micro-architecture, that can really push that. You can’t use clock-speed (frequency) to compare different micro-architectures, so that's irrelevant, don't get stuck on that. What's important is how much your CPU can get done per core clock-cycle. You can only compare the two when it's the same micro-architecture.
(Example: Intel Core i7-11700 vs Intel Core i9-11900).
Trying to compare CPU's by clock-speed (frequency) is a