Upir Likhyi is about as rousing a boss theme as you'll ever hear.
"One Piercing Note" is a quest designed around sound and music, and is the first quest to be entirely voice acted. When you first walk up to the abbey, you hear Valerio the troubadour playing an impressive tune. When you enter the abbey, you learn that they practice music in their worship. Their choir sings about St. Elspeth, and is also quite impressive. As you continue the quest, you'll wander between Valerio and the abbey a few times, and the music will change accordingly. At the climax of the quest, one more new track starts to play, "Citharede Requiem". It switches between the choir singing their song about St. Elspeth, and Valerio singing outside about the woman whose death you've been investigating. The two songs complement each other perfectly, providing an excellent backdrop as you chase the killer throughout the abbey.
Most of the Dungeoneering tracks really do fit with the atmosphere in the theme you're currently dunging on. On frozen floors there's random 'chilling' sounds showing that you are actually in a freezing area. The music is often rather slow too. In the Furnished floors the music makes you feel like you're breaking into a castle full of armed guards, hence the fast-paced themes. On the occult floors things get freaky what with all the necromancers, reanimated zombies and demons. The music is full of church organs, drums and ominous incorrehent chanting. The ambient sounds inbetween battles sound freaky too, as if the place was haunted. Finally, in the Warped floors, music becomes heavy, twisted, random and intriguing, fit with the theme of being too close to whatever grand power warps the guard dogs', rats' and brutes' bodies.