I played through it again about a year ago, and I think Modern Warfare (1 specifically, 2 and 3 are different) has at least some sense of ambiguity and ambivalence about it. In a lot of ways it is very face-value, pro-military shooting gallery game, but it undercuts itself in some ways that make me think that they were at least attempting to say something, even if I’m not entirely sure exactly what that is.
The American section of the campaign generally portrays a bumbling clusterfuck of a military force who can’t get basic information right and who are outwitted at every step. And while we take it for granted now, the death of the American player character was genuinely shocking at the time - after a big heroic rescue sequence (“leave no one behind” etc) the bomb goes off and they actually make you slowly drag yourself out of the crashed helicopter to look at the ruins of the city you have ostensibly been trying to liberate for the last few missions before the character dies of radiation poisoning.
The SAS side of the storyline portrays a casual brutality that almost makes me wonder if they weren’t trying to make some sort of point about how covert anti-terrorism operations are in fact pretty difficult to distinguish from non-state-sponsored terrorism.
I found the AC-130 sequence to be both a genuinely surprising break in the gameplay and to have a chilling effect, especially when I accidentally blew up a building and none of the crew cared.