I agree that the Prelude and the Main Theme always gets me pumped up and ready for adventure!
I also really like receiving a quest victory fanfare (not to be confused with battle victory fanfare).
I also like to see "[Name] leveled up."