Hell, I've been pulled over (and given a ticket) in nearly that exact situation you describe (I think it was more like 1am for me). Reasonable human discretion didn't help me that time.
> if an officer isn’t willing to be in the field to issue the ticket and show up in court to defend it then there shouldn’t be a ticket in the first place
I'm torn on this in general. The idealist in me really really really wants to agree with your statement, but the sheer number of cars on the roads means that cops see a teeny tiny fraction of things that happen. Driving-related injuries and deaths are disgustingly high, and I expect most of them are related to speeding, and running red lights and stop signs. That is, stuff cops are supposed to be policing.
No human-powered enforcement mechanism can watch for all of those. Yes, the usual deterrent factor applies: even if you are a butthole who doesn't care about safety, you might follow the rules because of the (relatively small) possibility that there just might be a cop nearby that sees you doing something bad. But clearly it's not really working all that well; car-related injury and death statistics are still (IMO) unacceptably bad.
I feel like this is sort of unique. Like, for other illegal behaviors, you can usually reduce them through other things. Like, have a healthy economy, low unemployment, under-control inflation, and housing that's affordable enough for everyone who wants to live in a place, and you have an environment where it's rare that people feel the need to commit property crimes. But drivers who speed are gonna speed. Drivers who run red lights and stop signs are gonna run red lights and stop signs.
Maybe -- like for many things -- better enforcement isn't the answer. Better road/traffic engineering, stiffer penalties for when people do get caught doing unsafe things... I dunno, maybe that will get us there. Perhaps we'll have some sort of a transit renaissance, and so many fewer people will opt to drive, and that will naturally make things better. Or maybe self-driving will get good enough (and be used pervasively enough, or perhaps even mandated) that riding in a car will become a lot safer, on par with train or even air travel. Who knows.
Regardless, though, I think my personal level of comfort is somewhere in the middle. I certainly don't want dystopian 100% panopicon-style enforcement of every single thing, where everyone is recorded everywhere they go to make sure they aren't breaking the law. But I think a light sprinkling of automated enforcement here and there is probably not harmful privacy/freedom-wise, but can indeed be a societal good. But I don't exactly trust law enforcement to stay within the lines of their mandate when it comes to these sorts of things. And I don't trust elected officials and judges to actually do something when law enforcement gets out of control.