Earlier quoted context omitted.
A big name in proc gen is Kate Compton who coined the term "10,000 bowls of oatmeal" to describe this phenomenon of technically unique but not different enough to matter - I googled "10000 bowls of oatmeal" to see if there was a good article and the second link was about it and nms https://www.challies.com/articles/no-mans-sky-and-10000-bowl...
One thing this article lacks is any tips on how to still do procedural generation while partly mitigating the oatmeal issue. In other words, define a more sophisticated generation procedure that can add character and identity. It probably won't be as good as an artful human designer hand-crafting a world, but it can be better than something overly random and blandly uniform in distribution.
If you don’t already have a fun game, then pro gen won’t make it any more fun than it already is. It turns a fun 1-hour game into a much longer fun game.
If every single Minecraft player loaded into only a single Minecraft world, it would still be as fun as it is. Would No Man’s Sky really be that much different if it just shipped with a handful of pre-defined planets? It might have less replay value but the gameplay wouldn’t be any different.
Good proc gen changes things in your game such that the player is given interesting reasons to make different choices each time they play.