A reviving and imaginatively tuneful second solo album brings ex-Nightwish legend back from the brink