It kind of goes without saying, but I do feel he's a bit under appreciated. Sure he's a doof sometimes and may a "saving people thing" from time to time but he's human, just like us. And considering what he goes through, we can all cut him a bit of slack.
I agree-- and Rowling makes such a point of keeping his body separate from everyone else, not giving him the honor of being placed next to the heroes of the war. In the movie, his body could land anywhere.