I feel that this is really 5e and 4e specific. 3.5 is kinda borderline and in my experience 2e and older definitely do feature things that are effectively “if you go in there you die, lmao” types of obstacles and trend more towards a sort of survival-horror tone, where surviving is in itself an accomplishment.