We found a tune called St Andrew's Day Parade on a sheet of music from a fiddle group, but no idea where it came from or who wrote it! Guessing it's from the American side of the pond as we don't do St Andrew's Day parades! (Though we DO celebrate St Andrew's Day in Edinburgh just a bit! Cafe Ceilidh in the Scottish Storytelling Centre 2pm on Tuesday 29th November for just one of several gigs!)
For a bit of fun, play "The Drunken Piper" slowly with lots of sliding on your strings to make it sound drunken!
And yes, "Hector the Hero" is well-known enough. Usually played in D around here, to suit the whistle players, but original key was A: nice to play it in the lower ictave first, then go up the octave for second time through.
And great list from Kenny.