Strategic bombing always had had the reverse effect to that intended.
The blitz on the UK. The much bigger bombing campaign is Germany later in the war.
The victims just stuck together and resisted.
V1s had an effect to begin with but once they could be counted it diminished.
V2s had a bad effect because explosions just happened but when radar can detect incoming and sirens and they can be intercepted, not so much.
I think the allies bombing of nazi Germany had an effect. It forced large diversion of labour (slaves, pow’s etc) to make new factories in mines/concrete shelters, with also diversion of time and materials to design and create.
That labour, time and materials would have been capable of producing more equipment, if they hadn’t been forced out from the unprotected factories by the bombing.
As for the ‘terror’ indiscriminate bombing of cities, then they’ll be collateral damage to infrastructure (especially transportation), which need repairs/replacing…. But as you say the affect of such widespread bombing on civilians is a bit more harder to quantify.
The V1 was probably initially a shock, but various tactics by the allies:
interception by fast planes, and then wing tipping it to disrupt the V1’s gyroscope sending it into a dive.
reporting that London hits were happening north of the capital, so the Nazi’s reprogrammed them, so they fell short of London.
…countered their potential.
The V2 was probably more of a terror threat, as no warnings possible. Luckily there weren’t many (see bombing above) and the allies were advancing rapidly towards Germany at that point.