As an over-arching answer, games that tend to look towards computations more than graphical quality tend to have more of a lean on the CPU. Games like WoW (MMORPGs), RTS as mentioned above, open world games tend to be more stressful to your CPU than other genres. Again, that's an over-arching answer, and does not take into account corner cases.