You can quite literally take entire courses in computer architecture and the relative performance of various components (CPUs, but also GPUs, memory architectures, etc.) and only cover part of it. You could probably take an entire course on branch prediction, which is itself only one of many components affecting CPU performance. So, CPU performance is a difficult and complex topic if you want to really understand what's going on.
But, just as you don't need to understand how a car's engine is built to understand whether it will be a good fit for you, you don't need to understand all the details of a CPU to figure out which one is better for you. Car review sites will have reviews covering aspects such as acceleration, top speed, grip, and I'm sure for trucks, how much they can pull how effectively. And sites such as Tom's Hardware and Anandtech will have CPU benchmarks - what's relevant for most people is figuring out which benchmarks apply more to them, and then seeing which CPUs do well in those benchmarks and fit your price range. Which can itself be a bit of a challenge, but it's less complicated than understanding everything going on behind the scenes. Similar to how you can read Car and Driver and get an idea of which car/truck will work for you, without reading up on the details of how the engine is built.
A relatively high amount of technical academic papers on CPU performance is available to those who wish to read it, and some sites' reviews also go quite in-depth on that. But even in the academic papers, benchmarks are often used to compare the practical benefits (or disadvantages) of the discussed topics - though the academic papers tend to go into more theoretical detail than many review sites. However, as mentioned, these are pretty technical and not Sunday-at-the-beach reading. Good for upper-level undergraduate and graduate school computer science courses, and actually interesting if you're into that sort of topic, but not what you're likely to find on the "New and Popular" shelf at the local library.
Edit: I'm not sure how many of the academic papers are actually freely available. When I was in college, it was easy to access them, but searching for one of them online now, it looks like it isn't actually free to the public. Unfortunately, a lot of academic papers wind up being like this - researchers do research with public funds, but only people who are actually in a university system have access to them. It looks like I actually have paper, not electronic, copies of most of the papers I read in college.