I don't mind the Pirates queue. There's not much to look at, true, but I think that actually is in the ride's favor-from the outside it looks fairly innocuous and if you'd never been to the park before you'd never guess it was one of the best, most elaborate rides. To my mind that's part of the reason Pirates makes such an impression on its riders: under-promise outside, over-deliver on ride. Whereas TLM at Magic Kingdom promises the most epic ride ever in the queue, and the hapless Undersea Adventure (or whatever they call it over there) can't hope to meet that.
It also helps that I finally learned to not use the queue on the left when it splits to avoid that awkward extended queue and get a shorter wait.
That said, they desperately need overflow queuing space. It's far too common to see it spilling out of the entrance. Mansion too-they could wrap it around the back of the house, if there's nothing back there.