I tend to drop them into one of five categories: Evolutionary, Revolutionary, Stop-Gap (or app-limited), Transitional, or Bad. Things like 11th Gen, 6x86, Prescott, and Bulldozer were stop-gap releases (sometimes you have to get SOMETHING out the door - other times it's all you have, even if it's not the best, or there's a flaw that keeps them from being the best but they're not BAD (the FPU on Cyrix)). The Core2, AMD64 x2, Zen2 and Sandy Bridge were revolutionary. The 8th/9th/10th gen Core chips were evolutionary. Things like Ryzen 1 / Alder Lake (arguably), S754 AMD64 were transitional (moving to long term platforms but short-term steps on the way).Exactly. A CPU being slow doesn't necessarily make it bad. What makes it bad is being touted as being a better performer than it is and or having serious technical flaws that create actual issues with their use. For example, the Pentium FDIV bug is a good example of that. When your CPU can't do math properly it is (and was) a problem. Bulldozer being power hungry, running hot and performing like crap (worse than Phenom II clock for clock) when AMD made promises to the contrary is another. Yes, it worked but the only thing it really had going for it is that it worked in existing AM3+ motherboards and it was cheap.
Bad things are the ones that don't fit into the above. Things like E1, the P1 with FDIV. Truly BAD CPUs are rare.