"Santa Lucia" and "Funiculi, Funicula" ( Yeah, I know. ) "Funiculi" may not be "haunting," strictly speaking, but it's got to be one of the catchiest.
Also beautiful is the Irish "The Wild Geese." Can't remember which Tradition LP I heard it on or who which fiddlers were playing it.