Alan Cumming has worked with Stanley Kubrick and the Spice Girls – now he’s starring in a dance show about Scotland’s most famous poet. He talks to Sarah Crompton about male desire, why Marvel films confuse him, and casting for the new James Bond