My favorite queue is in the Haunted Mansion at Disneyland. It usually moves very quickly, and the gravestone epitaphs, stretching room, and hallways make it fun and interactive to be in.
The worst queue I've been in Spellbreaker at Legoland. The ride was fun, but the queue was always long, and completely exposed to the California sun.