Starbuck's piano version of All Along the Watchtower from season 4 was a literal jaw-dropper. Not only is the song awesome on its own terms, but the way the song was played in that episode answered at least two of the season's biggest mysteries at the same moment.
Not to mention season 4's Diaspora Oratorio, which played as the fleet arrived at the first Earth. It's played completely straight, which just makes the reveal of Earth as a wasteland that much more heartwrenching.
Zarek was one of the few main characters not to have received his own motif, so when it came, it was pretty damn good. His character inevitably went to his death an hour later.
"Metamorphosis One" by Phillip Glass, which was featured in an early scene in the series, where Starbuck and Helo are sitting in Starbuck's apartment on post-nuclear-holocaust Caprica. The version in the linked video doesn't even begin to convey the atmosphere this piece creates in the actual episode. Original footage of that scene is also available on YouTube, albeit at much lower quality.
Neither is the final piece of music in the series. All Along the Watchtower - played by Hendrix.
Prelude to War is particularly epic in context — the scene where it's first introduced is flawlessly cut with the music, to the point where Adama hangs up the phone on the downbeat.
"Apocalypse" - the piece that plays over The Plan's ending credits, a rock remix of the series's opening theme.
Now with a live version. Who knew rock n' roll and the Gayatri Mantra would go so well together?
Razor also had a great ending theme, which isn't on a CD right now, but a soundtrack is planned for February next year.
All these listed and you leave out this one? AKA BSG can have some haunting music, make a great and atmospheric episode, and advance the plot all at once. Not to mention show off Alessandro Juliani's fantastic voice.
"Mandala in the Clouds" takes all the here-come-the-drums goodness of "Prelude to War" and "Storming New Caprica" and crank it Up to Eleven, with twice the speed and triple the intensity.
And then Bear turns around, writes a solo piano version, then plays it, has it taped in BSG camera style, and posts it on the internet.
Aaand then, in his continuing quest to melt your face off with every instrument on the planet, he does the same thing with a goddamn ACCORDION.
"Worthy of Survival", especially when it kicks into high-gear at the end.
Bear's three classical piano pieces "Battlestar Sonatica", "Elegy", and "Dreilide Thrace Sonata No. 1" are the most beautiful pieces composed for piano to be put on a soundtrack album. "Battlestar Sonatica" is an elegant tribute to Beethoven's Moonlight Sonata. "Elegy" is intended to sound as if it is being played on a wrecked old piano in a bar, and transcends the limitations of the instrument. Finally, "Dreilide Thrace Sonata No. 1" is the reason pianos were invented. It is absolutely lovely to hear, being written for a grand concert piano, is a masterpiece in terms of the complexity of the composition and sound, and is easily the most emotional of the three piano pieces, especially in the final minute and a half.
Of course, music by Richard Gibbs in the Miniseries is pretty sweet. "Are You Alive?" is wonderfully creepy.
And some of Stu Phillips' work from the original show has it's moments.
