Where Caen and so many other cases are concerned we need to recognize that really precise bombing in the modern sense was not often possible and seldom achieved in WWII, despite many claims to the contrary by the bomber barons. Aerial bombing had only begun about 30 years before 1944 so it was still a very young technology and most of the electronic aids available now did not exist. Even today, of course, guided ordnance can still miss the target and that was far more likely 80 years ago. Enormous strides had been made since 1939 and both RAF and USAAF were working constantly to improve accuracy. Low-level marking had already brought Bomber Command some remarkably accurate results that year, but as others have pointed out here that was still more the exception than the rule. Churchill was very uneasy about the effects of air bombing on the French, but as I recall De Gaulle said "c'est la guerre," or words to that effect.
^Yes it is also my recalling that WC was more worried on French civilian casualties as a result of Allied bombing attacks in 1944 than De Gaulle.
The head lines in the local paper repeated in translation on some posters greeted the Allies with "We waited for you with joy, we greet you with mourning"