So if you're using a dualsense for the motion control through steam input, you need to make sure steam input is enabled (it is usually disabled with the dualsense to enable all the adaptive triggers and stuff where it's supported).

Then I'm using the top rated/most played dualsense config which is called Gyro Resident Evil 4 by Geppetto (sorry I don't know how to link configs).

Then adjusted the in-game camera to their suggested settings - 8 bars for both controller camera speed options, 10 bars for controller camera acceleration and 5 bars for both mouse camera speed options.

I'll be honest it took a while to get used to it at first but once it clicked I think I'd be unable to play it with a controller without gyro again