Borderlands is pretty good, there's not really any team work, but it's quite fun on co-op, Left 4 Dead and Left 4 Dead 2 are fun co-op games too and feature a lot of team work.
Alternatively there is Alien Swarm, which is free on Steam, it's a little short though.