Precisely. Hand-made content, even badly made, reflects some sort of idea from the creator. Sometimes even badly made handcrafted areas contain interesting bits, and of course the well-made ones are absolute blasts to go through and can elevate even a game with shoddy mechanics.
Thief, Quake, Duke 3D, Morrowind, Fallout, Might & Magic, all these games live off their hand-made content: level design, quest design, encounter design, puzzle design. It's impossible to recreate the qualities of these games with procedural content. It has been tried, but always failed. Entire genres depend on hand-crafted content: FPS, RPG, metroidvania, puzzle, point & click adventure, etc etc.
The only games that can pull of proc gen are games that rely entirely on interacting systems. Strategy games work best here, because in a strategy game you and the AI work under the same (or similar) rulesets and the gameworld keeps changing due to everyone's actions. Paradox grand strategy games, Total War, Civilization, etc. Of course, a lot of these games don't even have procedural generation but are set on fixed maps of the real world: Paradox and Total War titles make you select a historical nation of your choice, then throw you into a certain historical period. After the start date, anything can happen based on AI behaviors. It's not really procedural content, it's the consequences of systems and actors interacting with each other. No random generation algorithm is running in the background creating new levels or anything.
Essentially, those games are PvP with the other players played by AI. It's fun because multiple entities interact with each other according to a complex ruleset, leading to interesting results.
But procedural generation in PvE games, where you play a single character and the world around you is essentially static, just leads to low quality content compared to what you can get from hand-crafted level and quest design.
Any single player genre that doesn't have independent AI actors benefits from hand-crafted content, and is not suited for the procedural.