I don't think any employer should require or request them besides the 3-letter agencies, to be clear. (I've edited my post to clarify that.) I agree it would be completely absurd for any other organization to require them, and I would never apply for a job with such a company or ever accept such a test; but I'm not someone who wants to work in intelligence or national security.
If you want to work in intelligence or national security, I think that's just one of the things you have to accept, along with being investigated and monitored and surveilled and all that. You know what you're getting into when you apply for such a job. I similarly wouldn't apply for any job that requires my employer to ask all my friends and family about my character and habits.