Video game writing is a vast subject and it depends on what I want to "get" from a game.
One of my favourite games, Okami, is very simple: You are a weakened god because people have stopped believing in you and you are walking the earth in the body of a wolf to defeat an ancient enemy of yours. Perform miracles and cleanse cursed areas to make people believe in you again, become stronger, defeat evil. There's no deeper philosophical discussion to be had either in-game or when you decipher the game, only "you=good, evil=bad".
Another favourite game of mine, or rather series, is Red Dead Redemption 1-2. The premise is simple: you are a cowboy at the ass-end of the conquest of the wild west, things are changing and you are forced to decide whether you stay the same or you change with the times.
The writing in RDR1-2 is a bit deeper than that summary and you play characters with a coloured past that catches up to them, starting the game's story. All of the named posse members have a clear personality with clear motivation, they're all flawed in some way and you get to explore most of the cast as you do the main storyline. None of the featured characters are clear villains, except for one who's a blaring red flag from the second he's introduced but he's not a boring obvious villain. Even the guy who's the big bad in Red Dead Redemption 1 is shown to have different sides in both games and you can't really reduce him to one single trait.
The kind of writing I hate is the shallow, forced diversity where characters haven't earned the respect they're given by the writing or they're flawless super-beings. "Strong" women opposite weak, toxic men who are written as squirming worms. I hate Mary Sues/Gary Stus. I hate games that force real world politics from Current Year (you know the kind, the politics that age like milk) into the game where it makes little to no sense.
As memeworthy as Hideo Kojima is and how forced some of his stories can be, I do quite like Metal Gear Solid as a series. Even if it has some political hot takes that have aged the games, I don't think they have aged as badly as some more modern titles made "for modern audiences".