I used to use Norton, Kaspersky, NOD, Avast Home.
Kaspersky is the most sensitive to new threats but CPU&memory usage is quite big.
NOD is resource-friendly but not so effective.
Avast is simply free, and i had no problems with it.
So, if paid - i'd go with kaspersky, if free - avast.