Not sure if there it was mentioned before, but the best systems I have ever found were always yellow or red star systems, with a gas giant with 3-4 satellites. When that happens, there is nearly always multiple habitable planets among the satellite planets, and all the satellites have low gravity, and the uninhabitables had no atmosphere. Additionally, these systems always had loner planets close to their star with extreme heat. That is literally all you can ask for. If you only have 0/+1 resources on these, it is already good; you will be able to make the habitable planets rake in 200-400k, and the rest of the planets make up to 100k, with the military planets still above zero. I am talking about no AI cores, Industrialist Admins, and 1-2 enhancements per planet, with only the habiltable planets going free port.
Hmm interesting, you have some screen shots of system/planets and colonies i could see?
I quit my last playthought, was annoying me to much haha. So in the process of learning not to repeat the same mistake again, rather not spend 30+ hours game time yet again.
edit/update:
so i decided to start a new game and use console commands to test some things.
Penelope system is a close to core system with many planets, i picked the one with highest modifier, which was a mining planet.
I spend story points on pop, port and waystation. And access is 138% which aint that high tbh, tho i only let a few cycles pass for the test.
The credits are decent though sitting at around 180k/mo. I aint sure if it will be left alone, and i dont wanna test that far, as its to tedious to hold shift even with x6 speed (max my PC can handle without melting).
Not sure what the test proves, but i dont think the access % is that huge of a deciding factor as to where to colonize. I did build/do all i could to lower hazard rating, which started at 225% and i cut that down to 100%.
Granted "this" colony will have sucked a lot of credits before hitting this stage. I honestly didnt keep count on the credits used, so when it will "truly" be profitable, i aint sure.
So what did i learn.. i think the system layout matters more than placement, and to a high degree what other planets/resources are there in the system. Think ill try a run where i pick suck system, and specialize each colony as much as possible. So only mine the highest resource one etc. Not sure how it will go, it might be just as huge of a time/credit sink as my previous attempts.
test colony:
https://imgur.com/a/m40yUkLNB: letting the game run while i ran around the house for a bit, lowers the net value to 140k/mo. but that might vary depending on "insert random stuff here".
edit2:
^^ random stuff.. are when there is a lack of resources for the various industry/structures. Fully decked out with alpha cores and no shortage of resources it reaches about 330k/mo. Free Port enabled. Notice that about 60k is taken for local storage to cover shortages.