One way to pick the "greatest" is to see which have been used for the greatest number of different songs. Some nominations:
Villikens and his Dinah
Tramps and Hawkers
Star of the County Down
Rosin the Beau
Little Old Log Cabin in the Lane