Well, Hulk: Ultimate Destruction made you feel like the goddamn hulk. And very similar, Prototype (haven't played the sequel) made you feel like a super human. I wouldn't say hero, because you are basically a walking monster and bystanders are just gonna die no matter what, but they were still awesome games.