Most people I know who have an adventurous personality don't smoke weed. Drinking I can see a case for as it's so heavily embedded as a social activity. Just anecdotal data I suppose but I'm not seeing a similar connection for having done drugs.

Perhaps for someone who is undercover and needs to fit in, sure, but I don't think that predisposes a personality to take drugs in their own time. For both alcohol and drugs I doubt it has any relevance to most intelligence roles.