I was speaking more about sandbox games in that regardless, like Rimworld and Factorio. The idea is that you focus too much on automation and efficiency rather than fun, and want to design your base in a "perfect" manner. Of course once you implement your design in production, you will see issues and want to optimize it more. And so on and on.

However as another commenter said, any game can become work if you want to achieve perfection. For example if you play an FPS game you can always shoot faster and more accurately - if you practice more and more. This can lead to a point where you don't find the game fun anymore.