Yes the music is very nice, and not over powering. I think one of the first games to ever have back ground music that did not over time get on my nerve's was Zelda Ocarina of time.
Sense then all game makers have done a much better job with there background music, and given enough volume options to allow some personal control.
As to the "If you're going to San Francisco ", it was some what nostalgic for me, and I hear in only in one tune that play's reasonably often in the game. But it does very much remind me of that particular song when it play's.