You are forgetting generation ships, ships meant to deliver the distant descendants to far away worlds. Of course, over those scales they might not make it. Or they could thrive under a sense of unity made necessary by the known nature of their craft. They may even choose to stay in space at a certain point. This topic is where you get the good sci-fi.