Most people really have no idea how hard it is to make modern things.
For example, go look at the effort it took to figure out how to make titanium viable as a working metal. Decades of work by thousands of people to figure out how to alloy it, how to bend and cut it, how to keep it from becoming brittle, how to repair it, etc. New tooling had to be made to handle the hardness of the metal. Until fairly recently, Titanium in products was rare even though it’s incredibly abundant, because turning raw titanium into an alloy and then shaping it into parts is really, really hard.
There will be a million differences between the way things work on Mars (or the Moon) that will require new research to figure out. Some things that are easy on Earth will be hard there, and vice versa.
But most importantly, modern manufactured goods are part of gigantic supply chains. A pencil probably has 50 companies and thousands of people in a supply chain to provide it. A chip fab probably has millions of people in its supply chain.
A medium-sized company can have 50,000 businesses in its supply chain. And each one of those businesses has its own supply chain. Even a simple part is made from assembly lines which have to be built, use solvents and other consumables that were developed over decades or centuries, etc.
Starting all that up on another planet is incredibly daunting, and will cost many trillions of dollars before self-sufficiency could be achieved. This is why we can’t just ‘decide’ where to colonize, or plan for a self-sufficient colony because we have no idea how to do that.
A colony, if one ever develops, will grow where there’s an economic need for people. It will happen organically and its nature will depend on what the people are doing. It’s very hard to see this happening on Mars. Not so much on the Moon or Asteroids. So the best bet for a colony is in one of those places.
Here’s a scenario for the Moon: A company figures out how to extract water from the regolith at an industrial scale. Automated machines walk the regolith on flat plains in the north or south, scooping it up and hitting it with microwaves and extracting the water and other volatiles into bladders. The water is then sold either to other lunar bases, or shipped into lunar orbit or the RLHO for use at the Gateway. Space Mining companies react to the availability of cheap water in lunar orbit by building mining craft that fuel up in lunar orbit, travel to the asteroids to extract minerals, then come back to lunar orbit to drop their payload and take on more water. A growing market develops for lunar water.
This causes expansion of water mining, the arrival of mechanics and others to maintain the machines, and perhaps a crew to start working on a mass driver so that water can be shipped almost free into lunar orbit. Profits go up, more companies join in.
All those people on the Moon start learning how to do things in 1/6 g airless environments. The Moon turns out to be a great place to manufacture things, as the environment is stable, the machines don’t have to worry about wind, water, erosion, yada yada. You can put a solar powered mining machine out in a field of regolith and it will mine constantly without interruption. Start the machine and leave it, and a month later you have barrels of titanium, iron, magnesium and other products, and bladders full of water, some argon, nitrogen, etc. Controlled environments are the best for automating.
Eventually as we learn to use more resources in situ, costs come down. More possibilities open up for working on the Moon. Explorers and vcacationers arrive, along with the people who will have to guide, feed and house them. Maybe a Saudi Billionaire decides a Lava Tube would be a great place to build a palace and a hotel/retirement villa. Disney builds a park. Soon thousands of people are living on the moon at any given time, either working or playing.
That still doesn’t get you to self-sufficiency, but it might get you to the point where the Moon is self-sustaining financially, and even profitable. Once that happens, time will tell but I could imagine continued growth and improvement until one day the Moon could continue even if a bio weapon wiped out all life on Earth. Maybe hundreds or thousands of years from now.
I can’t see a path to that happening on Mars. Maybe in the asteroids, though. It depends how much material is there. Especially volatiles like nitrogen. But the asteroids would be much more difficult to develop and inhabit than lava tubes on the Moon.