Agreed, similar to vaults in FO where you can learn about what happened in the vault through the computer terminals. I always found that to be a nice addition and made exploring the vaults more satisfying.
In OB I did occasionally wonder how people actually lived in those places, but not to the point that it ruined them for me. It would definitely be nice to see a more logical layout of the ruins in Skyrim with evidence that someone had actually been there at some point. I have high hopes for this area of Skyrim.
FO3 was much better than OB in making dungeons seem lived-in (currently, like raider hideouts, or previously, like vaults, and often both). Hopefully some of that carries over to Skyrim.
I thought the ancestral tombs in MW were particularly well-done - you could tell people had been there leaving offerings, made you feel like more of an intruder.