I would say what makes a theme song so wonderful is that when you hear it, it automatically reminds of one specific movie. When you hear it, you start humming or singing along and a song that gives you the chills everytime you hear it because of how awesome it sounds. That's what defines an awesome theme song for me :)

And those are the most memorable ones I could remember for now, there's probably a ton more I've forgotten.