I thought DS9 and Next Gen were both great shows. I thought the early seasons of DS9 were a little bland, but after a while it got a lot better. I'm afraid the original series was a bit before my time, so I doubt I'll see the new movie anytime soon. As Scottychaos pointed out, its given knowledge that Picard is way cooler than Kirk, anyway. But I also think Sisko is equally awesome.
I never got around to watching Voyager, but I definetly will sometime.