It's on page 22 of the July XBN. The screen doesn't look all that specal. Looks like it could be Rainbow Six 3 or something... I'm looking forward to seeing more, though.
Oh ok, from what it sounds like you'd really want to see vids of the game to appreciate it, sounds like the physics and dust/visual effects are where it's at.
If you actually read the impressions of the tech/feel demo @ IGN and GS, you'll realize they weren't simply going gaa-gaa about the static visuals of the game.
I wouldn't expect Black to be all that impressive in still shots. The impressive aspects of the game are supposedly the highly realistic gun handling and feedback and the highly interactive/destructible environments.