I like HeroClix for table-top gaming. I haven't played too many of the console games. Hulk for PS2 is okay, kind of average for a game. The Spider-Man2 game for PS2 is pretty good.
Has anyone played City of Heroes for the PC? You can play on-line with your friends and make exact duplicates of your favorite heroes, right down to the buttons on the costume. It gets addictive really quick (and that's just fine-tuning the look of the character).
To the person who said Spiderman 2 sucks, you got screwed. The PC version was made for dummies with crap graphics and stupid villians. The PUMA, for christ's sake?!? The consoles had a much better, free-form version. If you ever get a chance to play it on X-Box or PS2, I promise you'll change your tune. Nothing beats the thrill of learning to do stylin' swinging combos with blinding speed and precision.
edit: I guess you can tell where I'm throwing my vote, eh? Seriously, I have liked most of the spiderman games because he is a character with innovative powers that are fun to use, if only for a short time.
Good:
X-Men Mutant Apocalypse (SNES)
War of the Gems (SNES)
X-Men 2 Clone Wars (Genesis) <-----Personal Favourite
X-Men COTA (Arcade)
Marvel Super Heroes (Arcade)
X-Men vs. SF (Arcade)
MSH vs. SF (Arcade)
Marvel vs. Capcom (Arcade)
Marvel vs. Capcom 2 (Arcade, PS2)
Crap:
X-Men (Genesis)
Wolverine Adamantium Rage (Genesis)
All Marvel/Capcom games on PS1 except X-Men COTA and Marvel Super Heroes
So-So:
Spider-man/X-Men Arcade's Revenge
X-Men Legends...still half-way through it. Sort of on hold while I'm obsessed with GT4.