They don't unlock content, but it does unlock some fight or flight response. There are a couple side quests in the Shroud that are. Enlightening. Something something sweet home Alabama.

The above links will point you in the right direction you actually want to go down, though.