My favorite rope drop ceremony is the one at MK - lots of singing and dancing on the train platform while everyone is waiting in front by the Mickey floral, and then Mickey and a family that has been chosen do a countdown, and then the CM's drop the ropes to let the crowds in. Sometimes they will do it a little early and still have a second rope drop at each of the lands at the exact opening time.
AK has one as well where the characters are going on a safari. This one is neat too, but it's hard to see if you're further back in line since it's inside the park.
Studios has one as well, but it doesn't have the Disney characters. They do have some of the street characters making a movie that you are a part of when you come in the park.
I don't know what Epcot has b/c I rarely go there for rope drop, and when I have been there for opening I have entered at the International Gateway.