Smackhead Ent-D command crew would have been amazing. I think the closest we get in Trek is when Bones injects himself (accidentally, really!) with some wonky space-meds because of a storm above the Forever Planet in "City of the Edge of Forever" then proceeds to go completely, utterly batty and destroy the timeline. Don't do drugs, kids! You'll make Hitler win World War II!