My workstations at home and work are Xeon W3680's (6-cores, 3.33GHz) and are just plain awesome at everything they do. Most apps are not threaded enough to use 12 cores so I'd probably either go with a single 6-core CPU or a pair of 4-core CPUs to keep the cost down. You're probably better off with a few fewer cores that run at a faster speed.
That said, there are some apps that will take advantage of high core counts. I just put in a pair of new servers at work for virtualization with 32 cores each (4 L7555 CPUs, 8 cores per, 256GB of RAM) and at a job a few years back we had similar setups for physics simulations. It takes a lot of effort to make software that parallel (and not all workflows support it) and Adobe just hasn't gotten there yet.