By default all Spacial's forward axis are considered to be -Z
the one facing away from the camera by default.
Not sure why the devs have done this because every other 3D software uses+Z
the one facing the camera by default.
All of that is a trivial matter that you will eventually get accustomed to (or forever hate).
If you designate your facing direction to be anything other than -Z
then look_at
will need the offset from that direction.
Example
#so for your first image
look_at(player.global_transform.origin + Vector3.RIGHT, Vector3.UP)