Whatever cells it ends up in, the mRNA has them make the spike protein. That spike protein ends up attached to the outside surface of the cell that made it and it stays there [1].
If you injected spike protein directly, it could end up anywhere. I don't know if this has been tested in humans yet, but there has been research in mice where spike protein injected damaged their lungs [2].
[1] https://blogs.sciencemag.org/pipeline/archives/2021/05/04/sp...
[2] https://www.contagionlive.com/view/spike-protein-of-sars-cov...