Seconded. F-Prot being the runner-up.
Out of all the virus problems I ever faced:
NOD32 removed everything but one virus dll over a period of years (on a computer having something like 800 viruses on it, due to being a service-pack-less WinXP exposed to porn sites with Internet Explorer 6. Even so, it catched every other virus that said dll was trying to generate afterwards, making it easy to manually take care of. I gotta say, the windows desktop looked
extremely funky on that computer. I couldn't figure out how to restore desktop wallpapers on that broken installation ever since, without the nuking of a whole user account.).
F-Prot worked well, but every once in a while it didnt even offer options to delete an infected file. Resulting in continous nag screens sometimes. It worked fine and caught almost everything I threw at it though. A nasty virus which trojaned itself as freaking Explorer.exe (shutting it down killed the windows gui too, and restarting it restarted the virus as well) proved smarter though, F-Prot kinda choked on that and I had to manually disinfect the explorer shell and then clean up the rest with NOD32 - later I noticed that NOD32 actually found more stuff then fprot could.
I also used Norton for a while, but then ditched it when I noticed the extreme resource consumption and overall lack of effectiveness (got dozens of viruses on computers shielded by Norton).
NOD32 and F-Prot both used extremely minimal resources, I have NOD32 installed on my moms CELERON 400 running WINXP, and it causes absolutely no (noticable) performance hit.
Jam it back in, in the dark.