I also wanted to use the custom fields to do this. I didn't find anything pre-made, so I came up with this.
<?php $page_header_image = "path/to/images/folder/".get_post_meta($post->ID, 'header_img', 1);
if( strlen($page_header_image) < strlen(path/to/images/folder/))
{$page_header_image = "path/to/images/folder/default.jpg";}
?>
<img src="<?php echo $page_header_image;?>">
I have a bit more to do to clean this up, but it is basically working for me.
For this to work, you have to add a custom field with a key of header_img and the value for that key can be set to the name of the image you would like to use.
I included the path in the code instead of the meta tag simply because that was what worked best for me on this specific project. I plan on updating that later, but wanted to get this up.
I also have a test to basically make sure there is an image of some sort to display. If the meta tag comes back empty then a default image is shown.
Hope that helps anyone else searching like I was.