Procedural Generation vs Handcrafted for liminal spaces

What are the pros and cons of each option? Can procedural generation make liminal spaces look as good as hand crafted when it comes to detail and aesthetic? What are your thoughts? It's a question i thought of recently as I've thought of a game where you have to somehow survive and thrive in a complex that can generate and unfold into different liminal spaces that have certain resources and materials.