Shadowrun Dragonfall is probably my favourite single player story based game.

When I first beat it, I immediately started a new game and played it through a second time. It absolutely nails the difficult moral choices that so many games struggle with.

Also there's a dog!!

Hong Kong is good too, but if you're gonna play em both, start with Dragonfall because Hong Kong made some good quality of life upgrades to stuff like the inventory system and I'd hate for people to miss out on Dragonfall because it feels like a step backwards.