Actually the site used to be really useful. Somehow I forgot using it though. One day Ubuntu came out, the package manager (including dep mgmt) worked really well and there was a ton of great software in the repository. But in the tar xzf ... ; ./configure && make && sudo make install time it was really nice. I wished something like that existed for JS libraries.
But without resources like freshmeat, how are the packagers supposed to find out about new software to package. There is still one hell of a lot more unpackaged software than there is packaged, and finding it is going to become ever more difficult.
I'm personally quite annoyed by freshmeat's shutdown - I still checked it every (other) day.