I discovered this widget from Google that creates a custom 404 error page that suggests a good relevant page automatically for your user. If you have a site that gets a considerable number of 404 hits, you might want to check this tool out.
http://www.google.com/support/webmasters/bin/answer.py?hl=en&answer=136085