> but i often see the sentiment expressed that supposedly the entire class of software is useless.

AV software, including Defender, is not useless, it is actively harmful because it prevents people from running legitimate software without any recourse for non-experts or the original developer.