Can any game 10yrs in development ever live up to the hype?... No.
I agree people have a point about the graphics, they are far from cutting edge, but I knew that based on the various trailers released months ago. I found the AI to be very much like the original game, fairly stupid. How smart should a mutated LA Police Officer be? The weapons were cool, but I don't like the 2 weapon limit. I'm pretty sure Duke's line about the crowbar was an homage to Valve/Gordon Freemen.
Based on the Demo, I think I will at least enjoy the singleplayer campaign.