The moment that inspired this question:
A long time ago I was playing an MMO called Voyage of the Century Online. A major part of the game was sailing around on a galleon ship and having naval battles in the 1600s.
The game basically allowed you to sail around all of the oceans of the 1600s world and explore. The game was populated with a lot of NPC ships that you could raid and pick up its cargo for loot.
One time, I was sailing around the western coast of Africa and I came across some slavers. This was shocking to me at the time, and I was like “oh, I’m gonna fuck these racist slavers up!”
I proceed to engage the slave ship in battle and win. As I approach the wreckage, I’m bummed out because there wasn’t any loot. Like every ship up until this point had at least some spare cannon balls or treasure, but this one had nothing.
… then it hit me. A slave ship’s cargo would be… people. I sunk this ship and the reason there wasn’t any loot was because I killed the cargo. I felt so bad.
I just sat there for a little while and felt guilty, but I always appreciated that the developers included that detail so I could be humbled in my own self-righteousness. Not all issues can be solved with force.
It’s kinda cheating but The Beginners Guide is a game I think about all the time. As someone who makes things, the themes it explores about validation and the purpose for creating art really hit home.
For just a profound moment, the sun station in Outer Wilds.
HUGE spoilers
It really marks a turning point in the game when you find that out. I assumed like most people that it was a classic tale of science gone wrong, and now I have to fix it. As a video game it’s also really easy to assume that your goal is to fix everything - to save the solar system. But there is no villan, and no solution. You and everyone in the solar system will die and there’s nothing you can do about it. It’s a really powerful subversion of expectations that works well with the games themes.