Yes, 1987 had two movies named Scared Stiff.
This is the Lau Kar-wing-directed remix of Dreamscape.
Maybe some Scanners, too.
David Miu Tai-wai (Michael Miu) is a psychiatrist helping street people who is followed around by his friend Halley Tsang Siu-wai (Eric Tsang). For the first part of the movie, they get into wacky guy hijinks like pretending that Halley is a robot so that he can spills water all over a girl so that she’ll take her clothes off. Just when you start to follow that, David gets into a car accident, discovers that he can see inside dreams and has strange adventures like imagining he’s Van Helsing all while a researcher named Alice (Emily Chu) conducts experiments on his brain.
Then the movie turns into a chase, with the men who caused the accident chasing Halley into a parking garage where he finds a dead body and almost knocks out May (Anita Mui). As he recovers, he’s questioned by Inspector Chow (Chow Yun-fat) and another cop (Phillip Ko). Dabid decides to enter Halley’s dreams to learn what happened and discovers that the killer with a knife who murdered the person that Halley found — whew! — was Inspector Chow and he knows that they know that he’s a killer. And now this movie is pretty much a giallo!
What a strange movie that becomes a totally different story every few minutes. I loved it!
You can watch this on iQIYI.