Hah, you can just press M (I think it was M?) to automate the management of colonies. Never managed planets by hand as it's super boring and a bit pointless as you said. In general the late game is a bit bland as the AI is not very good even with the patch they delivered, but still it's quite a fun game and the 3D view was really innovative at the time.