McCabe and Mrs. Miller - it's about cowboy whores and The Sisters stole their name from it. Actually, one of the Leonard Cohen songs in it, stupid silly Eldritch.
I'd also say The Hunger, if that hasn't yet been mentioned. It opens with "Bela Lugosi's Dead" and stars David Bowie in a movie about vampire sex. Awesome.