There are agencies, iirc mostly law enforcement, that consider it a strict bar. It also depends on the level of clearance, and how much they need you. An Army private getting a secret clearance to present weather to the general on the daily isn’t getting nearly as much scrutiny as a nuclear physicist. But nuclear physicists willing to work for the government are a finite resource. It’s all clear as mud and the fear of losing your career over some stupid persecution is real.