Tarantino is the king of it, I feel. Also Scorcese's Goodfellas is incredible (his very famous "put Cream on the script, just put Cream in there"). But Moby's music comes to mind twice: the end of Heat and the end of the Jason Bourne movies. Perfection.
Name your fav use of licensed music in a soundtrack.