More threads are good for massively parallelizable stuff like video effects processing, finite element analysis and other large matrix math.
"More GHz" is more useful for applications that tend to be bottlenecked by their main thread such as the bulk of games out there and the UI of just about all software.