It has nothing to do with free or pro, they use the same signatures.
As has been explained avast isn't a specialist anti-spyware application but it does detect many spyware/trojan signatures. Having a multi application/level approach to security gives a better overall protection. No one program will give 100% cover.
Anything you find with spysweeper you could confirm is a good detection (see below 1) and if so send the sample to avast, so its signatures can be improved (see below 2).
1. You could also check the offending/suspect file at:
VirusTotal - Multi engine on-line virus scanner I feel virustotal is the better option as it uses the windows version of avast (more packers supported) and there are currently over 30 different scanners.
Or
Jotti - Multi engine on-line virus scanner if any other scanners here detect them it is less likely to be a false positive.
Whichever scanner you use, you can't do this with the file in the quarantine or avast chest, you will need to move it out.2. Send the sample to
virus@avast.com zipped and password protected with password in email body and false positive/undetected malware in the subject.
Or you can also add the file to the User Files (File, Add) section of the avast chest where it can do no harm and send it from there (select the file, right click, email to Alwil Software). No need to zip and PW protect when the sample is sent from chest. A copy of the file/s will remain in the original location, so any further action you take can remove that.