It depends on the cpu in question, the game, the video cards and resolution with settings...
At lower resolutions the cpu will be a bottleneck, but the gpu bottleneck is with higher resolutions and settings (AA+AF influence this alot). At 1920x1200 you would need a GTX285 tri sli setup if all settings are maxed to make the cpu the bottleneck in many games...