Holy crap, it's horrible.
I really wanted this to be good, and I loved Gearbox for doing Borderlands, but this is just not fun.
It was interesting for a while seeing all of the Duke nostalgia stuff, but it got old. Fast.
I didn't have high hopes, but it didn't even achieve the ones I had. The previews made it look awesome, the demo made it look mediocre, and the final game definitely followed the demo more than the previews.
I couldn't give it more than a 5-6 out of 10.
The "cool stuff" like the girls, fans, and random stuff (pissing, drinking, etc )seemed tacked on and doesn't add anything to the experience (except to add to your Ego meter).
I'd be pretty upset if I was actually one of the people who anxiously waited more than 10 years for this.