This movie has good effects as it is done by Stuart Gordon; however, along with those special effects we also get a whiny hero, failure all around by the good guys and an icky reveal revolving around the 'hero' and the strange girl with the fish bottom half! Totally not a terrible movie, but one that would make for an awesome Rifftrax!
https://www.imdb.com/title/tt0264508/?ref_=fn_al_tt_1