To Boldly Go
[Voyager] needed a kick in the ass. Creatively, we needed something. A Star Trek series, in my opinion, is only as good as its captain, and Captain Janeway was a great captain, but she didn't have her Spock or Data, really. We just didn't have that special science-fiction character like Spock or Data, the striving-to-be-human character. The idea of putting a Borg on board gave us a chance to have a wild child there. That was the metaphor, a wild child, and Janeway would be her mother and try to tame her and help make her human again. That was a new take on that kind of character. That's not to diminish the Doctor, Bob Picardo's character. He was great, but he really wasn't a foil to Janeway. He wasn't someone Janeway could play off of. -- Brannon Braga to StarTrek.com
Braga goes on to call Kirk a sex addict. We'd classify him more in the horndog territory... like an honest and romantically successful Zap Brannigan.
So... nothing like Zap Brannigan, I guess.