Someone explain to me the appeal of dungeons in some of these modules and how you're supposed to approach them.

Im a more narrative/social TTRPG enjoyer, but I done enjoy challenges, but some of these dungeons have some Dark Souls level retarded fuckery where you either have to metagame, read the designers mind, or just poke everything with the 6 foot pole meme, slowing the game to an dead stop and playing a glorified game of mother may I.

Why are they designed this way? How is this fun?