You guys are definitely mixing up "opening sequence" with "title sequence."
The Superman title sequence has the titles SOARING at you with the WHOOSH. The title sequence of a movie is just that, the TITLE of the movie and the credits presented in a creative way. The James Bond movies have some of the most famous title sequences of all time.
What a lot of you are describing are PRE-TITLE sequences. To use James Bond, again, as an example, the remake of Casino Royale has a great pre-titles sequence with Bond cornering a villain and flashing back to how he killed the villain's partner in a brutal mens room fight to the death.
Then Bond shoots the guy and you begin the TITLE sequence with the cool animation of men falling... shattering as they hit the ground... the theme song playing, while the names of the actors flash across the screen.
Hope that description helps.