CSGO takes advantage of multiple cores. It starts tapering off at around 4 cores, but it still showed gains all the way up to 6 cores:
https://www.youtube.com/watch?v=fj9cuHuTNVUIt very definitely takes advantage of far more than 1 or 2 cores, though, with 4 cores having ~2x the FPS compared to 2 cores.