Nina Simone may be a dinner party staple, but there is also a deep and darker side to the singer, says Ed Power