I actually find that when a website takes the time to create a personal and interesting 404 page, it signals the fact that they really care about user experiencer. 404 pages can be some of the most jarring things for a user and the fact that they shared some personality and helped the user get back on track says to me that the team is focused on the right things.