This answer to What drugs were commonly used within the Roman Empire? Were there illegal drugs? by u/x3k discusses drugs in the Roman empire, and while does not talk about bad trips, it does link to primary sources.

A briefer discussion is here Was recreational drug use as common in ancient times as it is today? written by u/QVCatullus