I agree, the absolute dumbest are Atlanta, Cincinnati, Cleveland, and the few others that require screening for inbound international passengers who are not connecting. It's an unthinkable waste of time and money. I can't believe that this is still going on.
As mentioned elsewhere on this board, the multiple ID checking airports are the second worst. It's wasteful, annoying, and--of course--there's no sensible reason for it.
Within the USA, BWI concourses C and D, Los Angeles Terminal 1, and Newark Terminal C seem to be the worst. The lines are ridiculous, and there just isn't any sace. It's always intimidating to pass by Terminal 1 at LAX and see the line going outside.
Outside the USA, the prize goes to Frankfurt for USA/Canada/Israel departures. How do you say "over the top" in German? It's an insane amount of security. And--how could we forget?--Heathrow. But everyone knows it's awful there.
I haven't been to Denver or Las Vegas, which seem to have some notoriety for slow security. And I've heard that the security in Moscow's domestic airports is actually far more intrusive and complicated than at Sheremetyevo. I haven't had the pleasure.