All hopped up on goofballs

I believe this is an allusion, but I don't know its source. My guess is that it's from American popular culture, probably a B movie. Net searches have fetched a ton of results, but none about the original source. Other than stimulants, I'm not even sure what 'goofballs' are. This exact locution has caught on for some reason, but where's it from?

Simple: Maybe my father is the source describing me and some friends way back when...
but seriously......
A goofball, at least here in NY, is a depressant--sleeping aids like Seconal, Tuinal--aka "downers".
Maybe someone else can fill in the rest.