Theres something along the lines like that near the end.
But in most E3 demos they're just nice scenes to entice you into buying.
For instance i was watching Bioshock Infinite and there was a scene where you and Elizabeth were ducking down hiding from the songbird.
Was that in the actual game? No.