After a disappointing 'Jekyll and Hyde,' the singer is back with a hair-metal hit that ranks among the top long-running productions