Yeah, grayanotoxins (or andromedotoxin or whatever) don't sound very fun, and we all know what datura is like (presumably).
Someone willing to put the work in could likely produce an interesting list of plant species for psychoactive honey. Attached are a couple of papers of possible interest:
Numerous pretty ordinary plant species are at least claimed to contain trace quantities of harmine in their flowers although the science in the paper was a bit weak.
Another study showed the presence of hydrocodone in nectar of a temperate orchid and this was shown to influence insect behaviour.
“There is a way of manipulating matter and energy so as to produce what modern scientists call 'a field of force'. The field acts on the observer and puts him in a privileged position vis-à-vis the universe. From this position he has access to the realities which are ordinarily hidden from us by time and space, matter and energy. This is what we call the Great Work."
― Jacques Bergier, quoting Fulcanelli