I disagree, I think the STAS intro is great. It captures the wonder and spirit of the character very well. Superman always gets great music, imo.
From those mentioned, I also loved the Thundercats intro very much. HO!!! Loved that show and wish they made a live action movie.
Another absolute fave is the Star Trek original series intro. Just the intro and music totally captured my imagination because it feels like the adventure of the human race. It captures the wonder of Trek and makes me want to be there with them exploring those worlds.