In our opinion, there has never been a great Spider-Man game. There have been some good one (and some lousy ones) but never a great one. Perhaps all that will change when Activision's Spider-Man Web of Shadows comes out.
According to Activision, Web of Shadows is combat heavy, with ground and air based fighting as well as web-slinging. The game is not based on a specific film or other work, so the game's developers had free reign to create a Spidey story that's videogame-centric. Speaking of story, Web of Shadow's plot details an invasion of Manhattan by symbiote, who infect people, ruin landscapes and generally ooze black all over the city.
Another cool feature: Suit-switching! The game allows for a switch from classic red spidey-suit to the new, sleek black. With great suits comes great powers: Each outfit changes Spiderman's strengths and weaknesses.
Web of Shadows will also feature several other Marvel characters, both heroes and villains, although who made the cut hasn't been announced. It comes out across platforms this fall.