I think there is a node to find the midpoint on a plane or line. You can define that plane or line using the two player pawns locations as the start and end positions. Then just have the camera turn to the LookAt Rotation with that point as the target. Also you can pull the camera back or change fov based on the distance between the players.