It should be fine for games. For example, I can play Skyrim on my C2D E6600. You can also use if for After Effects, but it may be a bit slow depending on what you are doing.
The only game you would have any significant performance penalty is Crysis 3. It actually needs a quad core CPU to get good performance (assuming the GPU is also up to the task).