The Scottish actor has worked with everyone from Stanley Kubrick to the Spice Girls