For only two people ?
One of the best one is Swat 4 + add-on.
You also have the FPS with bots like Unreal or Quake Wars.
After that all the strategy games are good to play at 2: Supreme Commander, Company of Heroes, Dawn of War + add-on.
And the racing games like Trackmania, Richard Burn Rally...