On the one side, you have settings like The Forgotten Realms, Harn and the like. On the other side, you have Blackmarsh and similar sandbox style settings.
Detailed to the level of knowing the privy cleaner in the tavern or a light touch, where it's up to the DM to determine whether or not there is a tavern in the village or not.
I'm on the Blackmarsh side of the discussion, with maybe a desire for just a wee bit more detail. I don't need more detail, but I'd probably like it.
Where do you stand?