To get a fair idea about how well different security products perform one can see the results of various tests performed by these organizations:
1. AV-Comparatives: https://av-comparatives.org/
2. AV-Test: https://www.av-test.org/en/home/
3. Virus Bulletin: https://www.virusbtn.com/index
These days all antivirus software have information about viruses stored locally in the users' systems and also a internet based cloud database having upto date information about latest viruses. Even behaviour of a file is analyzed and compared with the information in the cloud. So when the internet is on, the protection offered by security solutions will be higher. Norton and trend micro rely more on this cloud database. If continuous internet connection is not possible Kaspersky and bitdefender are better options but they may slowdown some systems. Bitdefender has large daily updates that can be an issue to someone whose internet pack is limited. In that case avast and eset are better options.
Bitdefender has recently released a free antivirus solution. It is a cloud av and hence continuous internet access is required. More info: https://www.bitdefender.com/solutions/free.html