Rotating player camera to a specific location

You can use “Find look at rotation” node, plugging in the location of your camera, and the location the player is (or is going to) as the target. Apply this rotation to your camera. You may need to rotate one of the resulting axes from this node 90 degrees to get the desired effect.

Edit: It would be helpful to have a “camera target” component in your player that the camera will constantly look at (using the method above) and then simply change the location of this component to control your camera’s focus.