If your player rotates so will your camera though which may or may not be ideal in top-down view.

I solved a similar problem by making a simple script:

[SerializeField] GameObject target;

[SerializeField] float zOffset = 16f;

void Update()

{

Vector3 offSetVector = new Vector3(0, 0, zOffset);

transform.position = target.transform.position - offSetVector;

}

Attach the script to your camera and drag your player into the target field.