It depends. If the non-technical person is so frustrated by SmartScreen being wrong all the time that they simply turn it off, or are instructed to turn it off by sites distributing legitimate binaries slandered by SmartScreen, then it's not a net win for security.