Obviously the first thing to note here is that Civ4 beats both games in the soundtrack department ;).
No, but seriously though, aside the ancient era where the music works mostly as an incentive to advance as soon as possible, Civ4's soundtrack is the only one in the series that I've felt...