Not very ghostly and not all that erotic either. I tend to be harsh on films that rip other films off without offering anything much that's new, and I'm not making an exception here. The rip-off this film does of "Witches of Eastwick" is so lamely done and unoriginal, it's almost sad. At least THAT film had Jack Nicholson at his scene-munching best. Here we have to make do with Manfred Wong who has a nice athletic bod and looks attractive with his rock-star hair extensions, but that's hardly enough to sustain this film.
Nor is the film's obsession with breasts anything to get too worked up about. There is the odd bit of full-frontal nudity (female of course, Hong Kong cinema isn't about to find equality just yet), but time and again the camera focuses on the nearest breast, no matter what else is going on in the scene. This is amateurish film-making, and is not particularly erotic either.
I find it astonishing that 20% of the IMDb users that have rated this film give it 10/10. Perfect film-making? Far, far from it.