Depends on the game. Some games are CPU dependent while others are not. In CPU dependent games a higher clocked CPU can provide better performance compared to stock speed. Examples of these types of games are Skyrim, Battlefield 3 (multiplayer), Hitman Absolution, StarCraft 2, Diablo 3, Crysis 3, Civilization V.
To a lesser extent Far Cry 3 does benefit from higher clock speeds, but it seems AMD's FX series CPU provides better gains in performance than Intel's CPUs as the clockspeed increases. It might be due to the fact that AMD FX CPUs do not perform as well, thus Far Cry 3 gets a decent increase performance. On the other hand Intel CPUs are already powerful enough and thus get smaller gains.
Games that don't really care how fast the CPU is as long as it is not too slow for the GPU are BioShock Infinite, Tomb Raider, and Max Payne 3.