Bottom line is that the game was not awful, but certainly not great. The modding community apparently feels it can do better. Enter the beta release of Perfect Dark: Source, "the result of a common passion" and "the concept of this game is the dream of all fanatic players."
Now that we're done smelling daisies and touching one another, I insist someone other than myself installs this and report back with their findings. I'll wait here.