Yes, Journey has been getting quite a lot of rave reviews lately and is being hailed as an art game. I'm not sure how much it adjusts its music to what you're doing. Most of the game is pretty scripted; there are not really any "bad guys" per se.
One game that comes to mind is Portal 2, which has some sections where the music responds to your actions. Beyond that, quite a lot of action-adventure or shooter games have some form of dynamic "music tension". Far Cry comes to mind, although it was fairly unsubtle there. Infamous and Infamous 2 did some amount of dynamic music tension stuff as well, and I'm sure plenty of other games.