I can vouch for Avast! and NOD32. I hear Kaspersky is good too.
I have heard of Norton 360 causing performance troubles, is difficult to de-install, and that it harrasses you to upgrade. N360 is also not free.
On my DAW I use Microsoft Security Essentials, along with the Windows firewall; have been using these since January 2010 with no problems. Both are lightweight and unobtrusive. They update by automatically as part of Windows Update. They're free and there's not even a yearly registration process like Avast has.
I think with the possible exception of Norton 360, there are definitely good choices.