Really? I don't know of a single war off the top of my head that didn't have many high-profile incidents of militaries targeting civilian infrastructure (with people inside).

Collateral damage is not deliberate targeting. Targeting civilians that are not participating in the conflict is against the Geneva Conventions:

https://guides.lib.unc.edu/militarylaw/armedconflict

Yeah, I know the 'rule'. The least messy war that comes to mind is the first gulf war, and that had loads of direct targeting of civilians[0]. Most wars (second gulf, various israeli wars, etc) are way worse. I cannot in fact think of a single example of the rule being followed, can you?

If you consider a really bloody war, like the korean war, they killed a fifth of the population of north korea, and destroyed basically every single piece of civilian infrastructure.

[0] https://en.wikipedia.org/wiki/Gulf_War_air_campaign