I'd like to see something like a ban/delete button too. Having just received a spam ticket by email, I then had to go through the drop down list to ban the email, delete the ticket, delete the user. It would be great if this was all done in one step. Anybody know what the MySQL query would be to do this?

SPAM is always an issue and I am actually surprised that this is not a bigger issue and the ability to deal with it is not a built in option.  Not knowing how you are setup, I am not sure if this is a workable solution but you could always use the "Ticket Filter" system to dis-allow email addresses  if it does not match the filters criteria.  At least this might give you a fighting chance.  I would also like to see some sort of captchya type of system as a filter option as this way if the filter fails then the user at least has a chance to submit a ticket.

On my forums one thing I did was a robot count down timer, where in this case the creation of the user ID could not be completed in under x amount of time and submitted, as then it would be tagged as SPAM.  The submit button showed the count down so those that were actually fast enough to beat the timer at least would wait for the timer to expire.

Also I use black lists where the users email is scanned and compared to known spammer database lists.

Just some ideas...