Hello @WillMead13
It looks like you are using GetWorldLocation, which gives you the absolute camera location, but then you are setting the relative location, which is local to its parent. Try using GetRelativeLocation instead.
I think that is the problem.