the reason being with SpawnActor you need to pass in a World space transform.
Which also means you need to transform your location into world space before you pass it to make transform.
also, you need to do it with a forwardVector instead of just actor location itself.
from your existing blueprint it would be more or less like
localPos = actorLocation + actorForwardVector*distanceBetweenObjectAndPlayer + eyeHeight vector
and then pass this localPos to a node that calculate world location for you before you make transform.