I think things are pretty good here, seems to be working for me. Spammers are always a pain, but the 3 flags things seems to work. I flagged a handful of posts as soon as I saw them about 8 hours ago, some of my flags were the third flagger and this site is quiet around then, but there was enough prepared to deal with the spammer.
I have nearly 20,000 posts on a non-music site by Hearst Corp. (magazine company) and they overhauled their site for the worse. They had a big user base, lots of established user supporting and encouraging new users that would evolve into knowledgeable and giving members themselves. Then they re-vamped, removed a user-moderator, the spam went nuts, but they had traffic and it was financed through advertisements. They killed that site.
I'm on a football (soccer) form, with 2 tiers. The lower tiers can be interesting, but often crumbles into petiness, fuelled by trolls. So you don't bother reading to much, just read the interesting and more respectful top tier. Then you have something valuable to give, and you realise you can't, you're a forum spectator.
I posted on Celemony's forum and PBend data on midi exports, and was faced with a notification that my thread had to be Mod approved. My reaction was 'FFS really', not a shouting angry 'FFS really', but one of deflation having gone through all the sign up rigmarole, to a from emails. Imagine that as a new user with a genuine issue that require more than noobie experience to resolve. Imagine you had spent ages researching before you reached for forum support. You may have even been reading the forum for ages, just never needed to ask anything. This stuffs important to us, we don't need things being more difficult. when things are being difficult enough.
I like this set up, I'm happy to flag, and others are, because forums belong to the users, if they don't, they set up their own ons that do. No site is perfect, but this seems pretty damn good. And we don't have to [URL] code to get blummin' hot links to work, just past them in. [IMG] is nice too