I think one classic album by the Alan Parson Project might fit this genre to a T...that being "Tales of Mystery and Imagination" (1976).
The whole album is based on some of the works of Edgar Alan Poe. It's a well composed LP that highlights some of the better known short stories such as the "Tell Tale Heart", "The Raven" etc.
For most of the cuts, they do to a large degree capture the basis of what Poe was trying to portray in his delving in the supernatural and all the horror that went with it.
There is the one song however, that is on the light side, "Dr. Tarr and Professor Feather" that ends up being a parody and well put together for a comic intent.
This album is best enjoyed after you have read the original story.
Q