How can I change the cameras CFrame while CameraType is set to Custom?

Do I need to modify the CameraModule in PlayerScripts?

What do you mean by this as off

You are only able to edit the Cameras rotation part of the CFame, trying to set the position of the camera while in the CameraType Custom will be reverted by the scripts running.

Only changes rotation, but not position:

workspace.CurrentCamera.CFrame = workspace.CurrentCamera.CFrame * CFrame.Angles(0,math.rad(10),0) * CFrame.new(0,10,0)