Naturally, any type of program music of the "narrative" variety, although its quality does not necessarily suffer if you have not read any program notes.
This trope applies to a lot of classical music. In twentieth-century and contemporary works especially, there may be a lot of details in the score, special performance notes, and analytical information that is known only to the performer or to a scholarly audience.
In the instance of Charles Ives's Concord Sonata - a musical depiction of the transcendentalist movement in Massachussets - a pianist may have read selected writings of Emerson, Hawthorne, Bronson and Louisa May Alcott, and Thoreau, as well as Ives's own "Essays Before A Sonata" (an extended program note on the sonata), performance directions, and numerous supplemental materials, and still have no clue as to how to interpret the work except by intuition.
The Second Viennese School of Arnold Schoenberg, Anton Webern, Alban Berg, and their subsequent influence turned out to be the apex of this in the early twentieth century. The techniques and aesthetics employed, including twelve-tone rows, athematicism, and non-triad-based harmony, had placed such composers at the furthest reach of comprehensibility while still maintaining a system that was, at least internally, organized by some logical system. You have to know the score well, in other words.
Parts of the backstory for the Rock OperaSpace Crackers can only be found on the band's website.
All of Coheed and Cambria's albums are about The Amory Wars, a sci-fi story by frontman Claudio Sanchez. The only way to truly understand the music is to read the comics, which so far have only covered about 2/5 of the saga. The rest is pretty much guesswork.
Without the stories that accompany The Residents' album Eskimo, all you'll be hearing are wind noises, tearing, and grunts.
Though you can understand the songs on their album Animal Lover, the manual does help a bit.
Avantasia suffers from this. Sure, the music may make some coherent sense listened to by itself, but to get the entire story, you need to read the liner notes.
Also, Blue Oyster Cult's Imaginos suffers from this. Doesn't help that they were in a botched track order by the record label...
The Who wrote two musical Rock Operas, Tommy and Quadrophenia, as both albums and stage musicals. The stories of both of these albums can be difficult to figure out using just the music and lyrics, watching the film versions and reading various analysis of the albums is required for the full story.
The same can be said of the mini-opera "Wire and Glass," though the originator of the kind, "A Quick One While He's Away," is blissfully self-explanatory.
Really, any rock opera qualifies. Including a lot of things by Trans-SiberianOrchestra. While the songs usually make sense in their own context, the backstory to them is usually found online or in the song booklet.
The Wake of Magellan shows a fairly disjointed narrative and the context behind real world connections seemingly out of place with Magellan's story.
The albums of The Protomen are packaged with liner notes containing pages of narration and stage direction which are not included in the music proper.
It is not too hard to grasp the story, although details will be lost without the notes. The first track of the first album begins with a narrator telling of Dr. Light building Protoman to fight an oppressive robot empire led by Wily. Proto Man dying is clearly told. Then comes an instrumental, followed by Light arguing with Mega Man about fighting and why he believes it is useless. The next two songs are of Mega Man deciding to fight and his lust for vengeance. Finally Face-Heel Turn Protoman's speech and their battle. The second album can clearly be conveyed to be of first "Tom" being betrayed by his friend while building a mechanical work force, then being framed for murder, then a youth fleeing the oppressed city, then the two teaming up and trying to start a revolution. As said, things like why Light built Mega Man and how the "revolution" occurred can only be understood from the notes.
Michael Nesmith's 1974 album The Prison was famously marketed as "a book with a soundtrack." That is, the album was packaged with an actual novella (written by Nesmith), and you're supposed to read it as you listen to the album. 20 years later he tried that format again with The Garden.
While Todd Rundgren's Something/Anything is perfectly listenable on its own, Rundgren's liner notes for the album put the songs into a more coherent context. Each side (it was originally a double vinyl album) had its own thematic concept, and on the last side, Rundgren turned an eclectic group of songs into an "operetta" via a clever liner-note narrative that linked the songs together.
Pearl Jam's "Jeremy" is about a kid who kills himself in front of the rest of his class. You wouldn't know this unless you saw the music video. And even if you did, it was more than likely the one that was edited to remove a key shot vital in making it even remotely obvious.
Roger Waters' Radio K.A.O.S. Try linking the songs without knowing the story.
Even if you do know the story, that still doesn't mean it makes any sense at all.
The mysteries presented for listeners in Nox Arcana CDs are near impossible to figure out unless you visit The Arcanum on their website. And even then, some of the puzzles (The Doctor's Office and Pirate Treasure come to mind) will still require visiting the "Hints" section of the forum. In a much less psychologically challenging vein, all of the stories in the songs are much better understood once you've read the full stories/poems.
The CDs of Standing Stone, a mostly-instrumental classical work by Paul McCartney, includes a poem that includes the storyline for the piece. The NPR broadcast from when it was released did not.
David Bowie's Rock Opera1. Outside has a short story in the liner notes setting up its storyline and major characters. Unfortunately, this only takes the story so far because the album was intended as the first of three; Bowie decided not to write/record the follow-ups, so the world will probably never know how everything was going to work out.
Pepe Deluxe's album Queen of the Wave is a Rock Opera involving an epic hero and the fall of Atlantis, based on the novel A Dweller On Two Planets. To pick up anything beyond the broadest strokes of the story (like, say, the characters' names), you need to read the album liner notes, or the "album companion" files that the band posted online. PD themselves said that they were more concerned about making the album an enjoyable listen on its own than they were about conveying the entire plot via lyrics.
The album Ghosts and Spirits is based heavily on C.S. Lewis' book The Great Divorce. Considering the nature ofthe book, understanding the references, conversations, allusions, context, and even the title is virtually impossible if you aren't familiar with The Great Divorce.