One of the major observations in Kim Stanley Robinson's Aurora[0] (which is excellent, well-informed, and worth a read) is that "99.9%" self-sufficient isn't going to cut it, at least for a multigenerational interstellar mission.
Reading Diaspora right now from a rec on hn and just loving the intentional handling of conflict in that as well.
I also love the ecological designing of each habitat -- whether to go with recreating a (likely lost) natural habitat or to create a new "Ascension".