For my DAW, under windows 8.1, I use the included Defender. Same for my office computer. Savvy users are usually fairly safe with this. Less savvy ones need to be protected from themselves with something a bit more aggressive plus need some amount of training about what not to click. We prefer ESET NOD for our business customers - especially where central monitoring is needed. McAfee and Symantec tend to be bloated and over-zealous.
We have actually setup virtual machines with Windows XP and Internet Explorer 8 and then literally performed tons of searches and clicked on everything - win free ipods, get help from a cartoon ape ads, etc :). We weren't able to infect the systems. Yet, we see people every week with all sorts of "fake AV" type scare-ware infections, FBI viruses, etc.
As an aside, backups are super important these days with some of the nasty stuff that's going around, like the much reported Cryptolocker. If you get this one and don't have a data backup, you're kinda screwed.
If you want a good third-party look at the whole lot of most popular packages out there, you can find one here with some great reports. Based on this, you can see that it's about a separation of about 6% or so between the low end (the out of the box MSE/Defender) and the best option. Here's the link - it's worth a look:
http://chart.av-comparatives.org/chart1.php (this is the "real-world" test result - it's a dynamic report/chart).
Hope the helps.