Yes, Superman was great.
Star Wars was also great, the opening note of John Williams' score was also great. Even the 20th Century Fox with the "LucasFilm" logo at the end, just feels better for Star Wars than any other film. I think Episode 1: The Phantom Menace was the best for me, cause I was so glad that wasn't altered.
Rocky was also a good opening sequence, simple and effective (and very original).
Might be a strange choice but The Breakfast Club is a favourite opening sequence of mine also. Good use of the Simple MinRAB opening, and its just a cool (if dated) begining, with the David Bowie quote.