Please excuse my lack of sleep lol. This is exactly what you want:
Just enable orient rotation to movement (and disable use controller yaw pitch roll). Make sure the camera (or spring arm if it is the parent) has Use Pawn Control Rotation set to True.