Aliens almost had a scene where instead of Amanda dying before she could reunite with her mother, she was still alive by the time Ellen was recovered. But, when Ellen attempted to contact her, Amanda accused her of Parental Abandonment and cut her off. Considering we don't get to see Amanda process her mother's message, it's possible her takeaway from the whole game is that conclusion.
Ricardo's Heroic BSoD after the synthetics wipe out everyone but him at the Marshals' Bureau is a tragic thing to see. He comes close to crossing the Despair Event Horizon, clearly shocked by what he saw, but no doubt feeling Survivor's Guilt of some kind for it. Amanda has to nearly shout at him to get him to just listen to her and try and compose himself again. If not for Amanda pushing him to continue helping so they both can survive, he likely would have given up and let himself die.
Ricardo's death is also pretty tragic since he's the character that works with Ripley the longest as Mission Control and is rightfully terrified the whole time. It doesn't help that he seems pretty young and frail compared to to the other characters. Amanda actually comes close to outright crying when she discovers his fate, which is by far the closest she comes to having an emotional breakdown in the game. Worse yet, the fact it isn't outright him dying, but getting Face Full of Alien Wing-Wong means that there is no hope for him, and that hopefully he at least died quickly when the station collapses and is destroyed.
Hopefully the Facehugger was still on his face - can you imagine the fear otherwise? Waking up... only to literally die as you do.
Sometimes you'll hear NPCs hiding from the creature, praying to God it doesn't find them and say they're not ready to die. Even if they were just shooting at you, it's still depressing to be reminded that these are people like you trying to stay alive, and that had the Alien not been a threat, they were probably decent people.
Some NPCs don't respond to Amanda at all - they'll just being staring out into space or sitting down with their head in their hands or, in one case, trying to buy soda. It's clear after everything that's happened they've just given up, not caring if the Alien kills them.
Some of the audio logs on Sevastopol can reveal some pretty sad stories.
Notably, the log called "Blood on my Hands" by Sinclair, chief of Seegson Security, which you encounter in Habitation Decks towards the end. On the log, a dying Sinclair reveals that the Xenomorphs have killed everyone, including his wife, and have taken his children as well, and that he was powerless to stop them. He then finishes by saying, "just send in the Marines or blow this place up. Take these creatures back to hell."
Spedding is dating his secretary, Suzanne, and to keep her safe, he makes the ill-advised decision to lock her in the showroom, oblivious to the fact that the Working Joe models therein that are "just for show" are still dangerous. Suzanne is murdered by the androids, and an unaware Spedding leaves desperate messages for someone to report on Suzanne's safety. He, too, is later killed by synthetics, and his last words are for someone to tell Suzanne that he loves her.
Hughes has a wife and child onboard and does his best to ensure their safety. He makes a desperate bid to try to establish long-range communications, leaving when his family is asleep so that they won't try to stop him, though he promises that he won't die and leave them behind. Unfortunately, he's murdered by a Working Joe as Amanda looks on in horror from the vent, and his wife and child presumably die shortly after.
Marlow's rant at Amanda on board the Anesidora outright has him blame himself for everything that's happened. All he wanted to do was save his wife after the Facehugger got onto her, he had no idea what monster he brought back to the station by doing so. When he shouts that his actions are essentially what killed her and doomed the station, it's clear how much he's crossed the Despair Event Horizon and is desperate to undo his mistake.
Taylor’s death, considering she’s decidedly NOT a greedy bastard like Burke, just trying to do her job for the company, is GENUINELY trying to help Amanda, and Amanda sounds genuinely grief stricken when she’s suddenly and without warning thrown against a window by an explosion. Not to mention it happens right before she’s forced to run to escape Marlow’s explosion, meaning she has literally no time to process it before she has to run, and then dive back into the horror of Sevastopol.
Ultimately, the fact that no one - NO ONE - except Amanda Ripley survived the Sevastopol disaster is a grand tragedy. Not her companions from Weyland-Yutani. Not the crew of the Anesidora. Not the people on Sevastopol Station. And not even the crew of the Torrens. Hundreds of innocent people died because of an infestation of a dangerous predatory alien species made worse by Human paranoia, greed and even good intentions, and Amanda herself barely survived all of it, let alone saving anyone.
In the novelization, there's a scene where Amanda just up and decides to travel to the spaceport on her eleventh birthday, convinced by little-kid logic that her Mom is just going to step off the transport like nothing happened, because she promised. Despite Weyland-Yutani already informing her and her step-father that the Nostromo has gone missing. She spends the whole day there, waiting for her Mom to just appear. . . and is devastated when she doesn't.
