The My House mod levels for the original Doom came out several months ago and it's a pretty interesting story that it tells, especially since it uses a Doom Map as the main storytelling device for a bit of a surreal horror type of narrative with a surprisingly deep story.
There's been a recent glut of 'horror/surreal' themed Doom modded levels coming out as of late and gaining lots of attraction but this is probably the most elaborate and famous one released so far.
What's even more neat is that John Romero himself gave the level a try, via a blind playthrough.
He certainly got through more of it then I did when I gave it a blind playthrough try.
And it's always fun progressively watching videos going more and more in depth with the things. Midnight, a Doom centered YouTuber and probably one of the more prominent ones, also released an hour long summary of his experiences playing this map pack.
Midnight's video was a bit of a stronger narrative as well since he also read the accompanying Word Documents written in a blog/journal style that were released alongside the modded map. And yes, there is a google doc file that is linked with the level download. It's a whole thing.
For those curious of the whole story though, the YouTuber PowerPak broke down his interpretation of everything in an even longer video. He actually plays the game on his own and when he gets as far as he can manage on his own, he then follows the Doomworld forum thread upon which the mod was originally released and read the posts chronologically so he could discover the full story semi organically himself.
All in all, it was a pretty neat concept using Doom custom maps as a storytelling device.