it depends on what you're running, but for a router more cores do help if you are running more components or have more traffic.
To give you a better example lets talk about a flow
Interface -> Firewall -> IDS (API back and forth via interface, simplified) -> QoS -> Interface
So in the traffic flow above, you cannot parallelise the flow but you can apply this process to every connection or packet, so every packet or connection can be processed in its own thread, and this is where having multiple cores help especially if running something like an IDS which can run on a separate core.
In some cases, you can parallelise the flow, but this is way more complex, like given the mikrotik CCR and its manycore architecture is not only to do with handling a lot of traffic but also the physical path. For instance the first interface can be nearer to the core that handles the firewall, and the core that handles the QoS can be different and closer to the output interface. A thread path below
Interface -> Core 1 (firewall) -> core 2 (IDS) -> core 3 (QoS) -> Interface . Given a manycore and a lot of traffic, multiple cores can run the same task, and it reduces the bottleneck of the frequency of each core unlike in the first flow where running all 3 processes on 1 core (even if you have many cores) will be bottlenecked by the core frequency, however the 2nd path will be bottlenecked by the internal bus, something that i've managed to bring my CCR to heel with testing which seems not limited by bandwidth, but by rate.
When comparing a quad core vs dual core, you also have to look at the architecture. Its not just the frequency but there are many components to picking a router.
1) Internal architecture. Look at the internal busses and SoC diagram. For instance, is the ram bandwidth 4x that of the max interface bandwidth? Is the architecture a bottleneck (like in the of the asus AC87U where wifi and ethernet ports share the same port to CPU), or in the case of dual one above 1Gb/s where doing so results in less than 1Gb/s (many consumer routers have this bottleneck). Then you have to look at the features like the radios and such if going for wifi, things like micro SD cards, SATA depending on your needs, upgradeable ram. Than you have to look at the CPU architecture. a dual core x86 at 1Ghz is faster than a quad core ARM or MIPS at 1Ghz, Every CPU architecture is different. ARM A7 is very different from ARM A9, MIPS 24Kc is different from the MIPS used in ubiquiti edgerouters.
When comparing CPU architectures, the architecture does matter for what you want to run. If you plan to run complicated QoS, you'll be better off with an ARM A9 than an ARM A7 because of the out of order processing in the ARM A9 which the ARM A7 doesnt have. So picking a hardware can be very complicated which most people dont bat an eye about.