The greatest artist of the 20th century has been characterised as a bully, a narcissist and a man who feared as well as desired women. But are the stories really true? Jonathan Jones tackles the six million euro question