Scotland's First Minister Nicola Sturgeon has been given an award by the German media for being "the voice of reason" in the Brexit crisis.