It's in the titles already:
Desire by Talk Talk, Desire by Peter Gabriel from the eponymous soundtrack of "Last Temptation Of Christ" with Nusrat Fateh Ali Khan singing - probably the closest you can get to desire / melancholy musically.
A good third probably Dream Brother by Jeff Buckley.