I've had Defender find a few viruses before. For the most part it has worked quite well and is light on resources. It is currently the main AV I use with my own equipment. I also try to maintain good browsing habits and use Linux (or a VM) if I intend to go someplace questionable.
With Avast I kept getting false positives; along with AVG and Avira. You'll definitely want to keep stuff backed up since those will remove files on you with or without your permission.
Norton, McAfee, Trend Micro, and NOD32 I stopped using a long time ago.
Bitdefender, Kaspersky, and Panda I've had good luck with. I have Kaspersky on my parents machine.
Malwarebytes works quite well for me (a couple false positives though). Honestly, I never expected AV programs to act as malware removal so it is always on mine and parents machines along with Sophos anti-rootkit.