Been to thousands of travel, high school and college baseball games over the years. Two walk up songs stuck out that I really liked and caught my attention, and thought to myself that is different:
Psycho Killer - Talking Heads
Good Vibrations - Beach Boys
Personally, I'm partial to "When the Levee Breaks" - Led Zeppelin. It is by far the best drum intro to any song. It is my personal phone ringer.
Good luck!