I have been thinking of this topic lately, and the discussion of 'Simple Gifts' and Lord of the Dance reminded me of it.
In opera, there is 'The Last Rose of Summer' in Martha, and 'I Dreamt I Dwelt in Marble Halls' in La Boheme.
Anyone else care to contribute to the list? Try opera, broadway musicals, and if you are really stumped, there are lots of movie soundtracks with folksongs.
(I won't try to define what I mean by folksong... just go for it!)
Alice in Montana