Have you tried Disco Elisium, by any chance? I'm in a very similar position - despite spending my whole professional life in gamedev, I'm mostly disillusioned in games right now. Especially from story perspective: too many titles seem to be written with the same old tropes targeted at teens, at best.

But among all the games that tried to challenge this in the last 10-15 years, Disco Elisium did it the best. It's not just a good story in a shape of a game: it's a very engaging gameplay, built very organically around a story and it's world and characters.