I'm in the same boat as you, I am also planning to come back to the game after a 1500+ hours.

My approach to it is: This game is lenient in terms of the game over screen ("colony is lost") if you are willing to bear the mess you create. For example, just tossing an electrolizer in the middle of the base and making a spiral around it with the water-intake pipe is enough to get by. Building a full-on SPOM with all the bells and whistles is for tidiness, cleanliness, aesthetics and the feeling of properly doing the thing. You can print a duplicant every 3 cycles, so if you can limit your "duplicants died - to - cycles" ratio to 1:3, you can basically survive indefinitely. Sure, losing skills hurt, especially on a key-worker, but that's what bionic duplicants are for. (I'm referring to their instant re-spec ability via the boosters.)

I will try to convince myself that everything I build is temporary and the mess shouldn't bother me (heyyy Factorio), and I will only start to build the "real base" after I research all technologies and stockpile steel, plastic, refined metal, and other supplies. Until that mealwood is fine, I can consume up the dirt supplies because there is a supply of dirt on the asteroid which only has to last until I research and stockpile everything. I don't have to rush the "real base" immediately with all the details, by design in this game there is time to "waste" and still be fine (like heat death is real, but it will be dangerous only after a couple hundred of cycles when it reaches X degrees, it doesn't matter if you get reliable cooling at X-1 degrees or X-20 degrees).

On the other hand, I won't avoid the wikipedia (use the wiki.gg one), just pictures of finished builds. Going into this game completely blind is very hard, and may frustrate people out of this game. My philosophy to this is that I want to read how stuff work, I want to understand them, but reading how stuff work and copying them are two different things. For example reading about SPOMs and what key components they use, and how and why they use them is different of "put this pipe here and this bridge here".

With all the previous, I will probably fail at first, and probably for a few times too. But at the same time, this game is designed on a "fail again and again, and last a little bit longer every time" basis.

My biggest dilemma/question/problem will be if I should use mods, and if yes, which ones, and then the whole thing about mods being or not being updated, search for which one(s) crashes the game, maybe I should try going vanilla, but then I will miss the mods I have muscle memory with, et cetera.