I'm sorry but those are some pretty disappointing results. What is the point of having such "great" signatures, that when it comes across unknown threats, it fails pretty badly. Real-time protection is much more important than static scanning rates. Their protection model is quite antiquated this day in age with all the constantly evolving malware out there. Get passed the signatures/heuristics and cloud, there is nothing left to fall back on which is clearly illustrated in the video.
And you can't really compare Avira to Emsisoft either. I don't think it's even all that close. And like someone said, you can't go off of 3rd party testing sites only. You should really test for yourself. Yeah their detection isn't as high as Avira at times, but their Behavior Blocker in my opinion is the best out there. I've been doing a lot of testing lately, primarily with Emsisoft IS and Kaspersky IS. Yeah Kaspersky usually has better initial detection rates but that's primarily due to it using KSN with scans while Emsisoft uses signatures/heuristics for scans and only queries it's cloud if something is flagged by the BB upon execution, but they usually have very similar results by the end. There have even been more than a handful of times lately that EIS clearly outperformed KIS because of it's BB. Got pretty badly infected earlier today with KIS, while EIS caught everything. And the samples I use are typically very fresh, 24 hours or less in the wild. So that is very impressive.
As for free solutions go, you gotta go with Avast. Very solid product. Better than most paid AVs. Much better than Avira. I like Bitdefender Free, but the lack of any configurable settings leaves much to be desired.