I have Pirates and Star Trek now, and owned Spider-Man for about four years before I traded it for something different. I'd take Spider-Man back in an instant, I definitely regret selling it. In my opinion, Spider-Man is the winner here. Pirates is fun too, but it can get boring a bit quickly. Pirates is the kind of game that I can't play over and over, but I like to come back to it from time to time. Star Trek is ok, but I feel like I'm having more fun when I play Spider-Man. The shots are more satisfying in Spider-Man, and the game makes me feel good about myself when I make shots (cool light and sound effects that are specific to certain shots). Star Trek has the warp ramp which is cool, but other than that I think Spider-Man is your best bet.
Good luck!
Jon