The one that comes to mind is from Moulin Rouge. It was such a popular movie and the song was central in it - although if we're going that route there were a truckload of songs covered in the movie. But Roxanne sticks in my head because it was so steamy, and the entire song was used instead of a snippet.