If you use the standard third person template, you want to change the character to make the camera “boom” be expressed in WORLD space, not RELATIVE space. That way, the camera won’t turn when the character turns.
Next, you need the actual Character to take the appropriate orientation based on control input. There’s a few ways of doing this; either you can turn off the flags that let the character take its orientation from the controller, and directly set the orientation of the character, OR you can lean into the controller orientation, and update the controller orientation based on inputs. Which one you do might depend most on where you decode user inputs; if you decode straight in the character, use the former; if you use the player controller, use the latter.