Welcome back to Unity. So I belive that I know the problem but I cant confirm it through comments since I dont have enough reputation to do so. If its somehow wrong I will make sure to update.

When you made the script you likly attached the prefab version of the player. The one from the editor section instead from the level scene. Which means that it will grab the vector3 position from the prefab instead of the current "live" one in scene. Since you likly have the prefab with the same or similar transforms as the gameobject that contains this script it appears like its spawning at the transform of the script.

The solution is to either use the prefab that appears in the level editor or have the player send its own transform to the script through a method.