I am, see above, a space nerd, formed by SciFi. But I wonder what the economical case for space colonisation above LEO, human or robotic could be. Asteroid mining is the typical use case, but again, I'm a sceptic. You'll need to mine the materials, separate them, transport to earth, down a non-realistic space elevator made from unobtainium and do all that cheaper than mining or recycling on earth. I don‘t see that for a long, long time.
European colonisation very soon had economic use cases, It started with spices, that very soon beaver furs, wood, plantations with the original sin of slavery and over the centuries the colonies developed into bigger societies which could produce industrial goods. What could Moon or Mars sell us that we want, that could rationalise a gigantic capital investment, which only could be paid back over multiple centuries? I don't see it, and I say that as a space romantic.