As Singin' in the Rain opens at the Palace Theatre, Adam Cooper talks to Matthew Hemley about facing cynicism when he progressed into musical theatre and why he no longer reads his reviews