A bit like politics, in that there are examples found at both ends, but most are in the middle someplace.
I find more use from short adventures that are easy to drop into my existing campaign. This means that I do not need much backstory on why the dungeon is there or who built it 1,000...