My favorite loading station is, or should I say was, Nightmare at Phantom Cave over at Six Flags Darien Lake. It had a really nice theme of a cave that twisted in the waiting line and you never knew what was around the corner.
Also, they had this lame/cool (depending on your opinion) video that was of some faux pas news footage of people getting lost forever in the Phantom Cave and that it was haunted. This was displayed on numerous televisions throughout the line, which helped kill time as you waited.
Even as you approached the actual loading platform, it was nicely themed with old fashion warning signs and a great atmosphere.
Even though the ride was a major disappointment after a hour wait, it was nicely themed. Unfortunately... it only lasted 2 years at Darien Lake.