3rd Person RPG Camera switching to 3rd Person shooter Camera?

So I wanted to switch the camera from the usual 3rd person game when right-clicking, the camera will go aim mode like all 3rd person shooting games and it works fine.
But the problem is my camera rotation seems to move kinda weird when aiming. When I move my mouse to the left or right, the camera seems rotate around the player (while the player also turning around) and not by the side of the player.
How do I change the camera’s rotation point while aiming in the blueprint? or any solutions? I hope I’m making sense… Dx Thank you