What makes it incredibly terrible besides the 15 year wait period?
The ironic thing is that if I didn't know that it was in development for 15 years, I'd go as far to say it was rushed.
The level design is terrible, the graphics are like something you'd see on PS2, and the gameplay is just unrefined and inferior to most other shooters out there.
But my biggest problem with Duke Nukem is that he isn't supposed to be funny. They're throwing this misogynistic handicap with bollocks for brains like he's really supposed to be cool. Compare him to Sam Stone, starring in a superior game with a protagonist that thinks he's badass but comes off as simply hilarious because he's actually so lame. Duke Nukem can't do that, nobody ever insults him for his lame jokes, his blatant stupidity is never noted by the other characters, he's just lame. He's not funny, he's not edgy, this isn't loving 1992, he's a dinosaur that should've never been rebooted in such a stuffty fashion.