Izhaki, I and co-workers have demonstrated that honey bees like nectar with nicotine and caffeine. Nice to know not just humans use cognitive enhancers.
Wild animals sometimes use intoxicants (besides using the drugs as nutrients) or even self-medicate, although I am unsure if anybody has good data on how common it is. It would be strange if the *only* effects of secondary metabolites in plants were to discourage consumption or provide nutrients of different kinds.