I read an 800 page FF7 fanfic where they manage to resurrect Aerith who then becomes involved with Reeve while Tifa and Cloud are expecting a child.

Depends on the game/genre. The Diablo and Warcraft novels supplemented the in-game lore and were competently written. And there's a lot of crossover between fantasy nerds and RPG players.

The actual writer for the first two Mass Effect games wrote some of that game's novels, too (which I have not read).

I read the old Worlds of Power books they put out back in the NES era

They were novels that doubled as strategy guides to various video games

They were poorly written, the Metal Gear one especially

My favorite thing was how the author constantly forgot how to refer to Solid Snake, frequently calling him Solid Snake Man among other things

I've read the first two Halo books. The first one details the start of the Spartan II program and John Halo and the initial Covenant bombardment of the planet Reach. The second book covers the events of the first game and, iirc, you could probably use it as a very unwieldy strategy guide for Halo 1 lmao

I read several of the HALO books when I was a teenager. They were mostly alright.

Allow me to introduce you to the litrpg genre.

How bout the Doom novels, those were fun. I don't remember the plots terribly well, I just remember enjoying them. It was a long time ago

I read the Resident Evil novelization as a kid and remembered enjoying it. I think Rebecca was the author's fave character as she stared in another novel based off the game.

I read the Halo books as a kid, but that's about it.

I bought the Baldur's Gate 2 novelization as a gag gift for a friend ages ago.

Does Sacred and Terrible Air count?

I read a Sonic the Hedgehog novelization as a kid without having played any of the games and it had the plot point of Sonic and Eggman being adoptive brothers so I was very confused down the line when that didn't come up in the story when I played the Sonic Adventure era games lol

Does the original DooM comic count? Rip and tear!

I read the prologue story for Amnesia:TDD and it got me to read Frankenstein and Lovecraft.

Anyone else read those Pathways to Adventure choose-your-own-adventure video game books as a kid? I had the one for Pokémon R/B/Y growing up, but they also had two for Gen II, another for Snap, and adaptations of Ocarina of Time and Donkey Kong 64. I think they're fairly paint-by-numbers retelling for the game plots with some gameplay tips thrown in (e.g. locations of items), but as a small child I found it absolutely entrancing for whatever reason (guess it doesn't take much at that age).