Coolest part about The Living Daylights theme was how John Barry worked it into the orchestral soundtrack throughout the film: https://www.youtube.com/watch?v=vrHRFGi6ULQ
Same with the use of the credits song by The Pretenders https://www.youtube.com/watch?v=aKiCV6CG4Sc
That's pretty common I think. Tomorrow Never Dies is a bit interesting because it uses the credits song, which was sung by KD Lang, not Sheryl Crow's song.