Which main processor (CPU) is recommended?

In today's day and age, we have reached a point where all processors are fast enough to perform any task you may throw at it. Gamers or video editors will benefit more from a more powerful graphics card than let's say, an Intel i7 vs an Intel i9 CPU.

Enthusiasts and people wanting to squeeze every bit of their machines will usually opt for the faster CPUs but it is not a must as it was in the past.