Ah, at my site I do a four part look at superhero video games and the comics they are based on called
Print-N-Pixel.
Currently I am discussing The Infinity Saga, looking at Marve Super Heroes (Capcom Fighting Game) and the Infinity Gauntlet along with Capcom's SNES game War of the Gems in relation to the Infinity War.
I know you weren't too interested in the older games, but this is a retro site and FiftyDollarCurse already listed some games so let me add on to it along with one SOLID recommendation for the PS2.
Here are some Comic Book Based Video Games that
I find good:
Arcade/MAME:
The Punisher
Captain America and the Avengers
Spider-Man
Cadillacs and Dinosaurs
The Marvel Fighting Games
X-MenSuperman
Batman
Alien vs Predator
NES
Silver Surfer (hard, but real fun if you have a Game Genie)
Batman Returns
Batman Return of the Joker
The Punisher (Operation Wolf style game)
Captain America and the Avengers
Genesis:
Chakan The Forever Man
Superman (1992)
The Life and Death of Superman
The Adventures of Batman and Robin (this game is inferior to the SNES version, but a fun Gunstar Heroes type game)
Captain America and the Avengers
Sega CD:
Prime
Spider-Man
Cadillacs and Dinosaurs
Batman Returns
The Adventures of Batman and Robin (its a driving game that is not like the Genesis port at all)
SNES:
Spawn
The Life and Death of Superman
War of the Gems
Saturn:
Marvel Super Heroes
Scudd The Disposable Assassin
X-Men Children of the Atom
PS1:
Batman Beyond: The Return of the Joker
Marvel Super Heroes
Marvel Super Heroes vs Street Fighter
Spider-Man
Spider-Man 2
X-Men Children of the Atom
Hellboy: Asylum Seeker
Hellboy: The Science of Evil
N64:
Spider-Man
Shadowman
Batman Beyond: The Return of the Joker
Dreamcast:
Spider-Man
Shadowman
Marvel vs Capcom 1 & 2
PS2:
The Red Star - I highly recommend this game, especially since it's on a more current gen system.
Superman: Shadow of Apokolips
The Punisher