My perception is that for consumer hardware raw CPU power stopped mattering some 10 years ago, it seems to me what matters more these days is CPU cache size/lat

My perception is that for consumer hardware raw CPU power stopped mattering some 10 years ago, it seems to me what matters more these days is CPU cache size/latency as well as RAM latency. Is this really the case? I think lately we have been seen a surge of efficiency cores because of this, turning on all that silicon to do just a little bit of computation and sitting idle is wasteful. My impression is that this applies to a lot of server infra as well.