In this case, two settings needed tweaking.
First is the scale. Since the file is an FBX, Unity doesn't know where it's coming from and what scale it needs to set. In this case, a scale of 100 worked. Most of the time it's either 1 or 100 (1m or 100cm).
Second is that if the camera (or object) has no parent in the DCC, you want to activate 'Preserve Hierarchy' so that a root is added to the prefab.
And lastly, 'Bake Axis Conversion' can be used to correct the handedness.