I don't think I've played a game where it was exactly like you described, but Monster Hunter and Relink both have hunts/missions that involve turrets. They're both four player multiplayer and usually you get two ballistae, and two of you choose to use them to help deal with the giant enemy while...