I think that Amazing Grace and Scotland the Brave are simply the ones people not only remember but may have been the only ones they've heard.

On a side note, I was asked to play Taps at a friends funeral earlier this year. They had a piper play Amazing Grace as the funeral procession enterd the cemetery. Here's the humorous part- I was kilted and the piper was wearing a suit.