The judgemental attitude and self victimization detract from your post. You’ll find people to be friendlier and more helpful to you if you manage to tone it differently.
Anyway! It sounds like you want games that prioritize being interesting over being popular? Dwarf Fortress would be my immediate thought.
Terra Invicta may be too high-level for the emotional impact, but it could fit. You are playing on the geopolitical stage, preventing (or steering) an exctinction-level war between humans and aliens. Stage a coup to overthrow a democratically elected government, make it as corrupt as possible to drive it to poverty so that the faction that wants to surrender to the aliens can’t win the space race?
The Last Federation where you play as the last member of an alien race that everyone tried to destroy, and your last act is to prevent them all from killing each other. Maybe you will harass them all to make them ally against you and become friends? Maybe convince 4 of them to gang up on the 5th?
Yeah, I’ve seen a few people wondering why the visuals were a bit dull and wondering if was the remains of The Escapist finishing them up to push them out and being lazy about it.
But it does by all accounts look like this was edited before the implosion, as they had literally zero employees left of the video team, including everyone who did video editing. The videos were all finished and uploaded to YouTube, just awaiting someone click the “publish” button.