Yes, Dwarf Fortress is a great example of what can be achieved. To provide some level of distinction, as in my other comment (which I will repeat here for convenience), there are at least two types of generation: generating the world layout and its rules, quests, plot devices, etc, and generating the actual visual content itself.