Wave Race 64. I always hear people talk about how awesome this game was. I cannot see why. I had Need for Speed: Hot Pursuit as well and thought it was shit.
I had that Spiderman/X-Men game someone mentioned earlier. I could never get past the first level. Of course, I was, like, eight at the time.
So far as movie games go, one of my favorite games ever is a movie game. The Warriors for the win. The problem with movie games, as I see it, is that the reason most of them are made is so that they can tie-in with a new release in order to cash in on the PR at the time. Rockstar owned the rights to make a game based on the movie for years before they actually did it. (I think I read somewhere that it is the favorite movie of a lot of the heads there.)