If I remember correctly, the first 4 or 5 Two Steps From Hell songs I listened to gave me goosebumps. After listening to them about 3 times, unfortunately, I guess I just got used to it and it never gave that effect again :/
Anyway, those songs were probably:
Heart of Courage
Protectors of the Earth
Strength of a Thousand Men
Invincible
P.S. The louder, the more epic