The term in your search suggests a need for modern compatibility. In 1990, fans relied on grainy VHS tapes or LaserDiscs. Today, the film has been preserved through high-definition remasters.
Another possibility is that you might be thinking of a different film or story that has not gained as much mainstream recognition. Erotic ghost stories or films that blend eroticism with the supernatural are not uncommon, but they might not always be widely known or might be restricted to certain audiences.
Released in 1990 and directed by Ngai Choi Lam, Erotic Ghost Story
In psychoanalytic terms, the ghost represents the return of the repressed—sexual, emotional, or traumatic. Erotic ghost stories of the 1990s weaponize this return, blurring consent, reality, and grief. The living protagonist often finds themselves unable to distinguish between haunting and intimacy, creating a liminal space where desire becomes indistinguishable from fear.