I think the site needs an overall redesign. It would be good to have things more image based. Since a game rarely gets downloaded without a screenshot, I'd think having a screen of the game on the main page instead of half the title cut off would make more of an impact. Check out http://xbox360.ign.com/
Instead of having a sidebar with What's New there could be a scrolling bar at the top that shows a pic from the latest games that've been uploaded.
I think the main focus should be:
1.) Recently updated projects (what has been most recently uploaded new, or what has been most recently updated)
2.) Recently Uploaded games or demos (this would be the scroll bar at the top of the screen)
I don't really see a need for having Downloads in both the What's Hot and What's New sidebars since if you look at them it's the exact same thing in each.
I've got an idea in my head that I might jot down. Site does need a visual overhaul, or at least the front page does.
IMO the Projects and Download pages need to have an option to view the title graphics too (or whatever the "main screen" is). I like the functional database layout as it stands but graphics are always nice