How to lock camera to Follow automatically and rotate only on command without scripts, empties
Instead of parenting, try a Copy Location constraint. Enabling the offset option allows the camera to follow the object at a set distance and it will ignore any rotation of the object it is following.