chuckebaby
abacab
I started using Avast about the same time as you, and would agree in general, up until last year.
But in recent years, Avast has tried to add every possible option to become a security suite. You have to be very aware during install to avoid the extras you may not want or need. Some things you even have to uninstall after the install. Even then, I once had an extra browser installed on my PC out of the blue (pushed by Avast during update, not during an install), without being asked. That was the final straw for me with Avast. Avast AV detection scores have also slipped slightly recently. I used to be a huge fan, but I have my concerns about the company now. Personal opinion 
I have been testing Bitdefender Free on a non-DAW PC, and it is light as well, but has limited scan config options. Set and forget. I think it may be a good runner up, if it doesn't conflict with anything on your system.
For the lightest resource hit and best Windows compatibility (and the lowest AV detection score), there is always Microsoft Security Essentials (Win 7) and Windows Defender (Win 8.1/10).
I know this is an older post but I still use Avast.
Its free and with free comes hoops to jump through. I have never found extra software installed except the browser clean up tools and auto software updater, exc but those are 1 click turn off/uninstall. There is no shutting down and reboot needed.
What it comes down to is sooner or later those free AV software's you are exploring will soon add other bells and whistles, more hoops to jump through when they gain popularity like Avast has.
I totally agree Avast has got heavier through the years but I have noticed little difference in CPU usage once setting it up correctly and even a good paid for AV needs to be set up correctly. so no big deal there.
Well nearly a year later, and I still will not run Avast on a critical system.
My choice for that is still Avira. It is nearly the most perfect AV that I have ever run.
But in all fairness, I do currently run Avast on a Win XP system that I use to run end of life software, that is not compatible with Win 10. It seems that Avast has cleaned up the install a bit and it is rather unintrusive now.
I also have a non-critical Win 7 PC where I use Bitdefender Free.
So in terms of my interpretation of protection and low system impact combined (based on 3rd party test scores), my recommendations now would be for 1. Avira Free; 2. Bitdefender Free; 3. Avast Free.
But back to the OP's question for a moment, it would seem that his motherboard hardware was outdated, and possibly not compatible with the nvidia drivers, related to real-time audio, based on his latencymon test results.
In any case, it should be standard practice to temporarily remove security software if real time performance appears to be impacted. But the LatencyMon test is the real key here.
Since the OP had no issues with the PC until adding the nvidia GPU, that introduced a driver that caused an increase in the DPC latency. It was weird that opening a browser did improve the score, but Firefox does hook into hardware acceleration, so there may have been some happy unintended driver interaction going on there.
If it had been my PC, I probably would have tried a Radeon GPU for comparison.
I have a 3rd gen Intel Core motherboard, and successfully tested two nvidia GPU's without impacting my latency. So it may have been due to the nvidia drivers running on an old chipset and BIOS that were causing the original problem.
Another good reason to run modern hardware in your DAW!