Omg, He's a Pirate. Such a goooooood song! omg! xD

I also like the one of Jurassic Park, Indiana Jones, Back to the Future, Superman, Star Wars, Mission Impossible, GhostBusters and finally Rocky

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.