I've yet to really see much of a paid security presence at any Tesla Supercharger other than maybe just basic mall security. However, I've yet to be at one where I was thinking it felt dangerous at night.
However, nearly every one I've seen was in the parking lot of some retail business (i.e. shopping mall) and/or tourist attraction. I've yet to use one, but I hear some Tesla Superchargers are at government buildings. This was the only one that seemed to be random. This one is in a seemingly random location. I guess the parking lot services a few retail businesses, but I barely noticed them. Mostly it was for several nonprofits and a public library. Kind of a weird setup though, with the retail businesses mostly served by a separate parking lot on the other side of the buildings.
https://www.google.com/maps/search/...904,-124.1953527,129m/data=!3m1!1e3?entry=ttu
From what I could tell - it was a little used parking lot that was in a fairly convenient location about a block away from the main drag - US-101/L and M Streets. But it wasn't in a big-ish shopping center complex nor attached to a specific restaurant. It also seemed like the kind of place the police wouldn't necessarily be patrolling as much as the main streets. And other than recent paving at the charging stations, it wasn't the most well maintained parking lot with lots of potholes. they also had this, which might have been interesting if I had a different car.
That being said, if charging stations ever become a point for criminal activities, I would expect an increased police presence. Perhaps it's unfair, but once reasonably affluent people start getting victimized at a specific location, that's when police act.