Duke Nukem Forever is not a good game.
To be clear, it's not the worst game ever made. It doesn't crash your computer (well, it didn't crash my computer, at least.) It is possible to get from beginning to end. It doesn't generally require a strategy guide just to progress. I'll even grant that it has moments that approach being entertaining, though not very many.
But it's a tragic example of poor design choices on so, so very many levels. It misses the mark on both what it tries to carry over from the old games and what it tries to update for the current generation. Its levels are painfully linear; bad guy drop-ins are so obviously scripted that it breaks suspension of disbelief. It's poorly paced, and its sense of progression and reward isn't well implemented at all. It's offensive enough to be uncomfortable without being daring or well-considered enough to feel either audacious or sexy. Its lack of confidence in its own graphics are made obvious by the amount of time you spend in shadows or looking through green-white night vision.
I've never played the infamous Daikatana, but what I've read suggests DNF isn't "Daikatana bad"- it doesn't game-over you because a stupid henchman got himself crushed by the terrain, it doesn't force you to sit through long, tedious narration (only the occasional short tedious narration), it doesn't make you spend the first fifteen minutes fighting frogs and mosquitoes.
And thus, it's not the kind of game that's going to give you tons of fun stories of the horror of having had to play it. It's just kind of depressing that so many people spent such an extended portion of their lifespan painfully bringing it into being.
If you really have an academic interest in examining how a game goes wrong, or if you're the kind of person who has to rubberneck at a traffic accident with everyone else, DNF might be worth $5. Otherwise, there are tons of games on Steam and GOG that will provide you with far more enjoyable experiences, even for $5. (The Binding of Isaac keep sucking me in, if you want a suggestion.)