Romantic prepper fantasies. With a couple hundred people, the bus factor of a tech society is wildly negative. Meaning, you'd need miracle spawns of workers already trained to keep up with just maintenance.

On Mars the whole thing would just collapse and people suffocate once the parts shipments from Earth were disrupted for a substantial period.