> Intel Pentium and Celeron-branded CPUs,

Don't look at the branding. Look at the core type, count, and speed (maybe).

It's been a while since I shopped Intel, but they used to typically release a low core count/lower clock speed Pentium/Celeron on the mainstream cores, often with no hyperthreading. These were typically low cost and could be a good value, you'd get decent single core performance because it's the newest architecture and multicore performance would be iffy but you can't have everything.

> N-class CPUs

These are definitely worth avoiding most of the time. Usually twice the cores, but much less performance per clock. Never feels fast for interactive work. But they make sense for some situations. Some of these get an n3 branding to trick people looking for i3s.