Prince Harry confessed to taking marijuana, cocaine and psychedelic mushrooms in his bombshell memoir Spare - which led to a US think tank arguing his visa application should have been made public