I wanted to take a moment to thank you for this detailed series, and resurfacing past issues as well, your assistance genuinely proves invaluable to the team, and provides a lot of needed details and context for us to help improve the game
As a retired programmer, I know how valuable detailed feedback is for finding and fixing bugs. I also try to adhere to the philosophy of always suggesting fixes and/or improvements whenever I criticize how something works.
As shown in the screen snapshot below, I have been playing Galactic Civilizations IV in its various incarnations for a long time. The game is outstanding because it takes you through an exploration phase filled with many discoveries (both good and bad!), a development phase where you create and develop your core worlds and research the technologies, and a war phase where you try to defeat your enemies. It is also outstanding because of the many customizations you can make to your own civilization, the universe (how big it is and what is in it), and the civilizations you will play against.
I cannot think of any other game that could hold my interest for all these years.