New biography finds the middle ground between the usual portrayals of sainthood or villainy, and charts a charismatic, very human figure who suffered mood swings, marital woes