Personally, I found Avast too clunky and too resource intensive (no where near as bad as Norton or McAfee, but too much for my taste). I liked AVG for a while, but now I'm trying out Microsoft Security Essentials. So far, it seems to work pretty well without leaving to large of a footprint.
But I'm trying, Ringo. I'm trying real hard... to be the Shepherd.