Is there reason to believe the stars are less of a dead end than Mars? It's easy to imagine us making a huge bet on interstellar travel, and just dying in interstellar space. Surely there's untold abundance in the stars, but if you can't actually reach it, then it may as well be a mirage.
Whenever I consider the possibility of interplanetary colonization, I come back to the conclusion that the only way to make it feasible is to reorient our economy towards sustainability in order to survive on Earth indefinitely. It's going to take a long, long time to develop the required technology, there's no real reason to believe artificial terraforming is even possible (since our sample size is 0), and even if it is it may take thousands or millions of years to complete.
I'm not being facetious with that last part, in the absence of information to the contrary, we should expect technology that works via geologic processes to run on a geologic timescale. I personally think artificial terraforming is probably possible, and that we could accelerate it to be much faster than the natural terraforming of Earth. But accelerating a 2 billion year process to be 10000x faster still takes 200k years. (ETA: I suppose a lot of that was the planet forming and the rate of bombardment falling to something tolerable, which eg Mars was already subject to, so maybe call it 1B/100k years.)
I did a lot of analysis for the problem of "build a solar sail factory on a carbonaceous chondrite asteroid that makes sunshades to deploy at the L1 point", particularly from a chemical engineering point of view.
One interesting thing was that a lot of the chemistry involved was similar to the chemistry of decarbonization and carbon capture, particularly when you get CO2 as a waste product it is too precious to vent so you are going to feed it back into your "petrochemical" line.
Objects like Ceres are the norm once you get out to the outer solar system, the difference is that Ceres is close enough to the sun for solar energy to be a good power source. Centaur objects, the moons of outer planets, and Kuiper belt objects like Pluto are similar but when you get far from the Sun you need to use a different power source such as D-D fusion.
If a species became independent of sunlight it could take advantage of very generic objects that exist throughout interstellar space (comets, rouge planets, etc.) and make the journey in hops of (say) 100 years from one object to another. At that rate it would be possible to visit another star system in 10,000 years with a comfortable lifestyle. People like that might as well keep comet hopping but if they came across a star system I'd imagine they start some project like a Ceres megastructure because it is generic you can find some object like that and be able to establish a huge industrial base and population larger than the Earth with the same head end you've used all this time and same comfortable lifestyle.
Earth would be priority two if that for those people. Grabby aliens might have disrupted Ceres but left the dinosaurs alone. But Ceres is here, so they were not. Ceres is such an attractive target that it should be a SETI goal to look for hardware left behind. Would be hilarious if they stole the Deuterium.
It's interesting speculation. I just can't accept the existence of a spacecraft that can last 100 years without a catastrophic failure, or Ceres being reforged into a factory, or a nation of people who live entirely independent of Earth until I see it.
Sometimes people talk about these things as if they are inevitable, but I would say there's an extremely good chance we go extinct without ever leaving this solar system (Voyager 1 notwithstanding). I think this is a valuable and grounding perspective in planning for the long term future of humanity, because we have to accept that that future takes place here on Earth and largely with the technology we already have. Space colonization is seductive, but like all silver bullets, impossible to operationalize within the constraints imposed on us by our situation.
But it's probably not a useful one when picking SETI targets or generating other research ideas, and that stands on it's own merit.
Whenever I consider the possibility of interplanetary colonization, I come back to the conclusion that the only way to make it feasible is to reorient our economy towards sustainability in order to survive on Earth indefinitely. It's going to take a long, long time to develop the required technology, there's no real reason to believe artificial terraforming is even possible (since our sample size is 0), and even if it is it may take thousands or millions of years to complete.
I'm not being facetious with that last part, in the absence of information to the contrary, we should expect technology that works via geologic processes to run on a geologic timescale. I personally think artificial terraforming is probably possible, and that we could accelerate it to be much faster than the natural terraforming of Earth. But accelerating a 2 billion year process to be 10000x faster still takes 200k years. (ETA: I suppose a lot of that was the planet forming and the rate of bombardment falling to something tolerable, which eg Mars was already subject to, so maybe call it 1B/100k years.)