I find them really boring, especially in RPG contexts. The difference is night and day when you walk into a handcrafted dungeon that has situational storytelling, creative direction, and ambiance that conveys a specific feeling. Bethesda games do this exceptionally well, for example.

Handcrafting a world also gives meaning to exploration; when I explore a procedurally generated world I feel like I’m just walking around aimlessly, looking for just another treasure chest or enemy to fight. But in a hand-crafted world, there are specific things to look for, situational stories to be told, or even secrets to find that the creator hid. That’s a lot more fun to explore than walking around in a glorified geometric algorithm