PC Dai and other sites do just about everything you listed. I actually think the advanced search feature, while a nice idea, is one of PCECP's areas in greatest need of an update. You're right, it is an old-style database, and this creates a number of inherent problems, the search being one.
I like the idea of being able to search by so many criteria. One problem, however, is the inability to utilize text searches for developer/publisher. You have to select these from a database list, and often times you'll get 8 million listing for, say, Namco and you have to look at them all separately. I can't just type in "Namco" and get a list of all the games their name is attached to, I have to sort through each of the listings, one at a time, and compile a list. This sort of thing could be fixed by migrating the database into a SQL sort of environment.
I don't care about user content or flashy presentation, but I'd probably use the site if the whole operation wasn't quite so antiquated. Good to know lots of people are still getting use out of it, though, so I'll be quiet since it's evident my opinions aren't shared.