I can tell you for Mechanical CAD models, both metrics matter. Same is true for CAM, which can generate absolutely huge data sets.
Additionally, Mechanical CAD (Solid Modeling) isn't multi-threaded in the vast majority of cases right now. There are some niches where it can help, but really we are still identifying how this might work.
For CAD, you want a very fast CPU and fast being single thread performance maximized, and then fast and a lot of RAM.
The order depends. Small, but complicated data sets favor speed over size.
Larger ones demand both.
On the software I work with, that big of a jump in RAM speed, coupled with a good CPU and cache can reach 30 percent faster update / build times. When those are seconds, nobody cares. When they are an hour, yeah. Big deal.
CAD is also compute intensive, meaning it's a great system stress case.