Regarding your question, examples that spring to mind straight away are:
Johanna - The Stooges
Desiree - The Left Banke
Beautiful Child - Fleetwood Mac
She Sleeps Alone - Epic Sountracks
Love You More - The Buzzcocks
Going Out of my Head - the Zombies
Though I Know She Lies - Chris Bell
If Words Were All I Had - Bobb Trimble