Well, if you like AVG you should use it but when it comes to malware detection rates, NOD32 beats AVG easily. But NOD isn't free
Well, it's hard to say wich is "better" or "the best" because it is really hard to test how good the antivirus is in real environment. I mean that sure you can have an antivirus that detects 90% of all known malware, but if you get attacked with custom trojan / trojans it perhaps can't help you and you can get hacked. Or there might be a 0-day exploit and if you are unlucky you might become infected a trojan wich is hidden with rootkit technology and all antiviruses do no detect that kind of activity. So I think if you want a good antivirus, it's a matter of your personal experiences more than test results. If your antivirus has save the day many times or you haven't had any malware you should keep it. I have used NOD32 for a long time and I like it and it's features and you should definetely try it. I think there is a trial version available or something...
I think the best free one is avast antivirus.It works great, is updated constantly,faster than norton,less of a ram hog...on and on.Avast has been around since 1988 beleive it or not! If your interested give this link a look.http://www.avast.com/