Kaspersky currently has by far the best detection rates, so if you're planning to use a paid AV, it's hands down the best choice. The free ones are all pretty much useless.
However, if you're not a complete fucking moron, AV is just a waste of system resources.