The story unfolds on Friday, April 17 at 4 pm in the lively setting of Venice, California. Here, we meet Huckleberry P. Jones, portrayed by Gene Cunningham, a local pimp and narcotics dealer who also happens to be a slumlord. While hiding some heroin in a vacant property he owns, he accidentally discovers a mysterious door that leads him to the Sixth Dimension—a bizarre realm from which he hastily escapes.
After securing his stash, Huckleberry sells the house to the Hercules family. On their way to school, Frenchy Hercules (played by Marie-Pascale Elfman) and her brother Flash (Phil Gordon) bump into Squeezit Henderson (Matthew Bright), who shares a troubling tale of his traumatic experiences with his mother and his vision of his transgender twin sister René (also portrayed by Bright). Squeezit reveals that René has fallen into the Sixth Dimension through the ominous door hidden in the Hercules' basement. Intrigued and anxious, Frenchy decides to take just a "little peek" behind that forbidden door.
Once she enters the Sixth Dimension, Frenchy is captured by the enigmatic Princess, who then presents her before the realm's rulers: King Fausto (Hervé Villechaize) and Queen Doris (Susan Tyrrell). The king develops an infatuation for Frenchy, inciting the jealous Queen Doris to instruct her frog servant, Bust Rod, to lock Frenchy away. To ensure Frenchy's safety, King Fausto orders Bust Rod to take her to Cell 63—home to the king's most cherished concubines, which includes René.
The following day, Flash becomes desperate to rescue both his sister and Frenchy, initially seeking Squeezit's help. When Squeezit declines, Flash turns to Gramps for assistance. While in the Sixth Dimension, they meet an elderly Jewish man who provides them with a plan to save Frenchy. However, they soon find themselves in Bust Rod's grip. Queen Doris decides to punish Frenchy and orchestrates a sinister plan that results in the relocation of all the inhabitants of Cell 63 to a horrifying torture chamber.
Just when it seems all hope is lost, Flash and Gramps escape, only to encounter an ex-queen who recounts her sad story of being usurped by Doris. Meanwhile, an explosive incident at the La Brea Tar Pit Factory leads Frenchy and her family to experience further chaos as Pa Hercules unexpectedly arrives in the Sixth Dimension after being blasted into the stratosphere.
In a frantic bid for rescue, Flash contacts Squeezit again, who eventually agrees to take action after facing his own troubles at home. Upon arriving in the Sixth Dimension, Squeezit finds himself ensnared by Satan (Danny Elfman) and is coerced into making a deal that could have fatal consequences. As plans to confront Queen Doris come together, further misadventures and chaos ensue, resulting in unexpected alliances and betrayals.
As the climactic showdown unfolds, emotions run high—Squeezit's severed head, sprouting chicken wings, thrives within the madness, revealing the sinister plots at play. Just as Doris stands poised to end Frenchy's life, she is interrupted by the ex-queen, igniting a fierce battle. Flash and Gramps arrive, and casualties pile up, leading to a shocking resolution.
In the end, the film culminates in a grand musical number that showcases the surviving characters as they gaze toward a hopeful future—one filled with ambitions of conquering the universe, leaving viewers to ponder the wild adventure that led them to this moment.
