He’s known for his good-humoured, down-to-earth and affable personality – and now he’s telling his own honest story as he opens up about the highs and lows of being an 80s music legend