Well Doom III got revealed over two years ago, and looked amazing and still does today. We get to see an Unreal 3 engine tech demo... I'll guess it'll be at least a year till we see a game that uses it on store shelves. I remember how long it took for the Unreal Warfare engine to get used in a game (I think it became UT2K3).
Regardless of all that, yes it looks insanely good.
