Yeah, I didn't really think this one was that bad. CoD's STEs are the way it's always handled scripted moments, and it seems like a perfectly cromulant way of doing things - by pressing the button, you're acknowledging that you're handing over control to the plot for a moment, without having it snatched away from you like games did in the oldern days (and without leaving you free to jump around the plot and teabag the coffin).
It's not like it's cramming the need to pay respects into the multiplayer - it's confined to the campaign, and it's not completely unreasonable to expect CoD to show you a story when you elect to play Campaign mode, is it?
Maybe I'm in no place to argue, though - I didn't pick up on the moon dust talk in Portal 2, so was totally puzzled by that final encounter, until my girlfriend, who'd been playing on her own PC and had just done that section herself, pointed it out. It's fair enough, as an ending, but I think people would be a lot more bothered if every problem in every game had to be solved with the same basic left click standard attack.