I don't have much experience in this genre, but I do enjoy the Simpson's Arcade Game, Turtles in Time, and the Scott Pilgrim game.

Oh, Comix Zone is great too. I forgot about that one until I saw it in your post.