I feel like the theme of “The hero being disappointed with the reality of their mission” has good ways of executing that are hard-hitting rather than just dismal. Spec Ops: The Line, The Fall, Papo & Yo, and The Sexy Brutale were all great iterations of this, building up to harsh late-game revelations.