Generally agree but I think it's important to make a distinction between federal law enforcement and local.
Local police departments have wildly different training and qualification requirements. Most famously generally not requiring a college education, having the right to pass on hires/fires because they score too high in IQ tests, etc.
At the federal level college is often a requirement up to including law degrees and PHDs[0]. One thing to look for at that link - the starting salaries and requirements are wild. The relatively low pay and high requirements likely either select for people with a strong sense of service or power crazed maniacs.
Most federal agencies other than the FBI have a single, consolidated training program at FLETC[1] (the FBI has their own in Quantico). Additionally, they generally have higher standards and regulations for everything from behavior to investigations and overall professionalism. This story includes multiple call-outs from agencies tasked with overseeing federal law enforcement (however effective they are). At the local level in many cases the only "oversight" is some citizen review board with practically no power or a useless internal affairs department.
In short, to be a "local cop" you can generally decide to be one (for whatever reasons), go to the police academy a short drive from where you live, and be walking around with a gun in a few months. It's very easy and low-effort.
That's not the case at the federal level. At the federal level you also don't have the whole "get fired or resign from one department, keep your certification, and get a job in the next town over" situation - which is ridiculous and basically serves as a funnel and retention system for bad cops.
LE is people too and you have the normal distribution of humanity (more or less). However, the job tends to attract people with a longing for power and that's problematic too. There's also the issue with LE generally, but especially local police, where they have a tendency to get extremely cynical and jaded.
I don't see myself as some "bootlicker" or whatever the current derogatory term is but I have been on a few ride alongs and spending hour after hour dealing with people at their worst can really wear on you - and I have roughly 24 hours of cumulative life experience observing this. As one cop said "for starters, everyone lies to you constantly". Frankly I can't imagine doing it day in and day out.
At the risk of going way off topic here, I can sympathize with how jumpy these local cops can get. Being by yourself, on some random dark street, pulling someone over, and walking up to the car cold is surprisingly scary. It's the little things - I was in the passenger seat and I was told I could walk up to the car with them but only if I walked around the back of the police car and came up to the drivers side behind them. You know, just in case the driver decides to put the car in reverse and pin me between the cars. There were a few situations that were dicy enough for me to realize "I'm the only one without a gun or body armor".
Most local police departments have ride along programs and I encourage everyone to do at least one. It's easily one of the most eye opening experiences I've ever had.
[0] - https://www.secretservice.gov/careers/special-agent/qualific...
[1] - https://www.fletc.gov/