It is worth separating noisy narrative from those who did not care for Nicola Sturgeon's policymaking and leadership from the reality