It depends on how much you can overclock it. At stock speed 965 x4 is past its prime. At a good overclock, its not a bad budget cpu.
I"m using one right now @4.2ghz. BF4 plays perfectly well with less than 10-14 players. If I get on a map with more people I seem to fall "behind". I suspect it is more due to my DDR2 than anything else.