Assuming the team chooses to make The Haunted a retail product -- complete with what can only be described as a portable zombie blender -- consider us pumped. See the full list of Make Something Unreal winners, courtesy of Big Download, after the break. Also be sure to visit the Make Something Unreal website, where you can download all of the winning entries.
Update: As some commenters have pointed out, the team responsible for The Haunted is not ModDB -- which hosts the mod -- but rather an unnamed team headed by Michael 'Hegi' Hegemann. The information has been corrected in the above post. The team's work can be seen at hells-reach.com. Joystiq apologizes for the error.