Blew me away might be overstating, but there was a superhero named "Warren Peace" in a cheesy flick (sky High) from years ago that still makes me giggle.
As a flip-side, what would you consider the most generic, everyman sort of name? In other words, the last name you'd expect for a hero/villain to have? My current short list is Larry, Bob, Jim, Bill, or maybe Murray.