Game Maker's Toolkit has an entire video on adaptive soundtrack implementation: https://www.youtube.com/watch?v=b0gvM4q2hdI

One of my favorites is Splinter Cell Chaos Theory where the tempo and intensity of the music matches the alert level of the enemies and the tension of the situation.