Oh come on! If those were my base motives, I would want to be Celeborn, husband of Galadriel, the Noldor princess and fairest of all elves! (excepting maybe Luthien).
If I were to be in Lord of the Rings, I’d like to be Treebeard for a week, right before and after the invasion of Isengard - one of most satisfying occurrences in fiction of a villain getting his just deserts.
Other possibilities:
Louis Wu, flying over the Ringworld.
As previously mentioned, Sherlock Homes, while solving one of the thornier cases, maybe the mystery of Silver Blaze, which offers a nice little trip to the countryside.
Or the man who proved himself smarter than Herlock Sholmes, french gentleman-adventurier Arsene Lupin.
Finally, d’Artagnan, the most famous of the musketeers (yes I know he wasn’t really a musketeer at the beginning hence the title). Perhaps around the time of his duel with the 4 englishmen and subsequent seduction of Milady, though of course I would sneak out without revealing myself, instead of stupidly sticking around until the morning after and making her my deadly enemy.
Bullitt. As in the Steve McQueen character in the film of that name. Because Cathy, his gf, was played by Jacqueline Bisset. She’s still the perfect woman, even now, but back in 1968 she was even perfecter.
Admittedly that would probably be for the betterment of the galaxy, but…
You know, I can’t actually think of a counter-argument. Except for Janeway’s hotness, about which I am sure many of y’all disagree. And even that doesn’t make up for the swath of suffering and murder that was her career.