Symantec Endpoint Protection v11 is the best AV out there, period. Most other "recommended" AV products use Symantec's definitions, first of all. Second, none have a comparable network deployable solution, even if that doesn't matter for normal end users. Third, the included firewall and network activity monitor can't be touched by NOD, AVG, or Kaspersky.
Resource hog? Who is not running a dual core CPU today anyway...
A 25MB memory footprint I can live with when it's faster, more thorough, and by far more configurable than anything else on the market.
Then again, it's not really a consumer solution. For that, I'd have to say AVG since it's free even if it isn't that great. It's comparable to the other crap that you have to pay for.
Symantec is a company that makes lots of security products, including the Norton line of consumer crapware. Stay away from anything Norton-branded for sure.