If you want to exact match to earth in our solar system line conditions , i.e. G-5 star with a rocky plant in the water zone and not too close to a binary if any - you would end up with only few possibilities in 1000Ly

However say red dwarfs with moons of closely orbiting gas giants, and many other combinations could in theory be sustain life easily .

We can learn from history on earth, economics is the reason why cities or outposts form and die, even when they are very hostile or very unsuitable and expensive to make it work.

Space would be no different, people would be happy to setup an outpost on Betelgeuse despite its impending supernova if they can say get away from regulation or it cheaper to make things for some other reason, or there is ideal low gravity planet with the right conditions for growing some thing even it would normally be considered hostile .

Thanks so much, I love your comments here!