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

Dreamaniac

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