"Camera Parent Lock" can be useful when rigging cameras, but it's not
intuitive, and has also generated a LOT of confusion. This is because
it breaks the fundamental parent <-> child relationship conventions in
Blender, and there is absolutely no indication that it's intended without
diving into the preferences.
I easily found 14 bug reports about this behavior on the tracker, which
probably means that thousands of people have been confused by this.
T27459: Flymode moves parent
T46107: Camera parented to amarature
T48821: Fly-through mode when in camera view moves 3D objects parented to the same object
T78607: Model rotates with view when parented to camera
T43055: Fly/walk view nav cause parent object to move with child camera
T31881: lock camera view problem
T28803: "Lock Camera to View" will drag everything inside the hierarchy that the camera belongs to.
T69048: Lock Camera to View is not working correctly when camera is child of an object
T48656: A parented camera in fly mode moves it's parent.
T75543: Рarented camera moves parent, in navigation mode (regression)
T76436: The camera moves the parent into camera view
T45790: Parented camera moves the parent object when manipulating camera with "Lock Camera to View" enabled
T78934: Lock Camera to View Also Moves the Parent
T78607: Model rotates with view when parented to camera
Even if we leave this preference on by default, there is now an indication
right next to the camera lock property, so any confused user can easily
find the "problem."
Before
After
Note that I adjusted the UI label from "Adjust Parent" to "Affect Parent"
after making this video.