Is that because more cores for a given transistor count better addresses today's computing needs or because we've hit a limit where adding more transistors to a single core doesn't give us more performance anymore?

It's because the design techniques that allow a core to run more instructions per clock -- wider execution units, shorter pipelines, etc. -- also tend to reduce the maximum achievable clock speed.