I think Sean Connery jsut amplifies whatever he's in. If it's good, it's really good, but if it sucks... well...
Pirates looks really cool (it's got a zombie monkey - how can it be bad?), I'm hoping maybe my gf will cave in the we'll see that instead, but I guess I'd suffer through LXG to see the special effects again (those are excellent, even if the rest of the movie's crap).