Dwayne ‘The Rock’ Johnson breaks his silence on being cast in Martin Scorsese’s new movie, calling it the “most creatively inspiring time” of his career