What are some albums that follow mythical stories?
I know one so far, Legend of Arthur and the Roundtable, but I want to learn about more and listen to more for inspiration and the story telling potential it holds.
Blind Guardian - Nightfall on Middle Earth is all Tolkien mythology
Rhapsody of Fire was created their own middle earth inspired lore and all albums are chapters in it
Black Metal:
Summoning is all about Tolkien mythology including some songs in Elvish.
Rush's early albums were themed. The first was a plain rock album, but after that were theme based. Their fantasy themed albums were
Fly by Night
Caress of Steel
A Farewell to Kings
2112 was more sci-fi, and then after that they were more mixed, with albums containing fantasy or sci-fi, or just political or contemporary topics. But there's a lot of material to listen through.
Aside from their historical or political stuff, none of the fantasy is tied to any particular folklore; it's just fantasy stories. You won't find, like, songs about Merlin, or Achilles, or whatever
I'd absolutely put Hemispheres in there too. The first track of Hemispheres is a direct sequel to the last track of Farewell to Kings. Also Xanadu from Hemispheres is very much a fantasy song.
Grave Digger has several albums which follow both fictional and actual stories. Notably there are three albums known as the “Middle Ages trilogy”: Tunes of War, Knights of the Cross, and Excalibur.
Not exactly on point but there's a pretty good album by the group ASM (A State of Mind) called The Jade Amulet. It's a concept album set in the fictional ancient kingdom of Vabaria. The story revolves around Shalim, the last member of the clan Tan Suo. It's more feudal Japan than mythical, but worth a listen.
Here's my favorite song from the album, which features MF DOOM:
Moonface's "This one's for the dancer, This one's for the dancer's bouquet" is half about the Minotaur making peace with the various gods and people who imprisoned him. The lyrics to all the Minotaur songs are really hard hitting for me.
FYI, Moonface is a solo project by one of the members of Wolf Parade.