I used it from 2000ish until around the time that apt-get became good. I can't ever remember a time when sourceforge didnt make me try to click on ads when attempting to download software.

It was certainly a valuable tool and definitely the GitHub of its time, but man- soooo spammy.