I don't know if this counts, but I always liked the "30 Century Fox" logo at the end of Futurama episodes.

I really like it when studios customize their logos. I just think it adds something to the film. And it's really neat to see how they try to play with it. Because, let's face it, some of those studio logos (ie Warner Bros) are really boring, but they can wind up doing something neat with it (like Warner usually does).

SPOILER AHEAD:

Check the opening segments of Speed Racer and Get Smart. Just suggesting.

Great stuff, but most of it from recent years.
The Matrix trilogy also have good openers, very dynamic and mysterious with all the little pictograms and symbols (no doubt all having special meanings).
Way back when… the opener of Kevin Costner's Waterworld also had the land masses/ continents of the Universal Studios Earth being flooded as the camera zooms in on the ocean.
Also, if I remember correctly, didn't the Burton Batman movies have special WB logos?
With everything digital these days, it's much easier to redo the logos…