If it's sealed to the point it can't be looped it's useless because it has to be able to connect to the grid to power it. If its connectors can be used it can be looped, which makes it a bomb.
If the crazy lizards are involved then it's not a plan that's feasible long term. They're leaving and don't want people to be dependent on them to start with.
It has to be a solution that can be implemented by the SGC/Asgard to be feasible. Also you specifically quoted the generator from canon, not all these redesigns you're talking about now.
If you want something feasible and sustainable it needs to be a stationary emplacement, black boxed to high hell, and tamper proof.
You're running headlong into the same problem as using those tiny Arc Reactors of Tony Stark's to power cars (they're more than capable; hell they're capable of powering towns) but they're also a damn fine bomb. You need a custom design for your purpose and the naquadah generators as designed by Samantha Carter based on the alien design are not it.
You start with a link to the Stargate gadget, so you know the general class of thing being discussed - not everyone is familiar with the same fictions, and I like to give the unfamiliar a chance to understand. The 'one per leader' is a taster, the equivalent of the 'free samples', which demonstrates the tech - and it's made clear that this is just the tip of an immense mountain of tech that Earth (and their nation) might gain access to. As a taster pretty firm one-off precautions can be taken against abuse. Any slightly smart leader should at least suspect this.
Shorting the power to try and get an explosion - I'd expect a shut-down, followed by a cool-off period. And maybe a 'maintenance and training' message from the gadget, sent to the suppliers.
Longer term, anything will likely be fixed-installation, yes. And, I'm pretty sure the Asgard have some pretty cunning engineers, who will work with human
tiger teams to try and figure-out not just fool-proofing, but malicious fool-proofing.
Tech is sometimes talked about as coming in three stages: basic, established, and baroque. 'Basic' is better than the Carter design, and you rely on experts to keep it happy and working. 'Established' works for most people as long as they follow the training/instructions, and rarely fails catastrophically unless long abused. 'Baroque' allegedly works well and safely for everyone, but has lots of 'useful features' that few understand, and even less use. Then, a new cycle starts, with new tech, again at 'basic'.
Yes, you can provide pretty reliable 'alien tech', no, you can't completely guarantee to make it malicious fool proof. High density power supplies can't be made totally safe, even if they are black-boxed and incorporate low-grade AIs.
A fun 'generator' might be a really secure black box with a dimensional power receiver in it, and, a note "If you're reading this please expect a visit from a Family maintenance person".
