There will never be a technical or operational process that excludes cheating. The only deterrence that seems to work on humans and even then only most of the time is severe capitol punishment and that will only be as effective as people believe it happens thus requiring live streaming of the removal of cheaters heads without censorship. The current legal process of each country would have to be by-passed or people would just sit in a cage for 30 years. Even in such cases there will be people that sacrifice themselves if they think that bribe money can go to their family but that is at least a start.

Also cheating with paper ballots is much harder to scale and remain undetected than cheating by altering records in a database.

I agree with your point that attempts at cheating are inevitable, the rest is confusing though:

We have a long and storied history of coming up with extremely disturbing capitol punishments performed in public, and yet those punishments coexisted with much higher rates of criminality then now.

Stealing from the church in history carried some pretty gruesome deaths, and yet plenty of people still stole from the church, etc.

People are chronically bad at transferring future risk to their current decision making. Any consequence that relies on people being able to model a future problem against their current desires/needs is always going to have a lot of transmission losses. You end up trying to make ever more horrible punishments to overcome the losses in transmission.

I think the goal should be the smallest possible functioning consequence, which is possible by being close to the 'crime'. The very best way is when community can do it immediately. Like if someone does something fucked up, but then their buddies go 'that was fucked up dude', I am very confident this will prevent then from doing it again much more efficiently then a distant jail sentence. (among all the other ways too, there's never one clean action to take to solve problems on a societal level)