Dreamaniac

You don't have to live on Elm Street to have a nightmare.

A heavy metal musician strikes a deal with a satanic succubus to make him successful with women, in return for the succubus being able to feed on the girls.