The last of the Stuarts is hardly England’s most famous or successful Queen, but she endured hardship and despair few could imagine