I feel that if games like Deus Ex or Dishonored had some form of co-op they could be a lot more interesting.
I recently played some co-op in a game called Streets of Rogue and it made the game a hell of a lot more fun. I'm also excited for Ray of Hope, a co-op mod for Stalker.