I had a symmilar issue, though I actually spawned bullet projectiles and had them oriented from the gun’s muzzle to the point where the cameras line trace hit the target. The problem was that the bullets were always going a bit to the left of the target location, even though the line trace was hitting right on the crosshair.
The solution for me was using the Impact Point of the camera’s line trace as the target location for the Find Look At Vector. Now the bullets land right on the crosshair.