Milk by the band Garbage is a prime example.

Emma, covered by The Sisters of Mercy is also a good example.

Some Kind of Stranger is another by The Sisters of Mercy I was once fond of.