I agree with your assessment 100%. My friend has 2 of them, Lord knows why. I tried to dissuade him...
I've shot them, and here's what I experienced, from the standpoint of using this as a carry revolver...
.410 - Personally I just don't trust this round for self defense, the ballistic performance on the dedicated self defense ammo is not impressive. Plus the shells tend to stick in the cylinders after firing making a speed reload too time consuming.
45 ACP with Moon Clips - much faster to speed reload, but if the full moon clips bend, you are in a world of crap, so not an option for me. Half moon clips are probably the best option and I like the 45 ACP for self defense
45 Colt - the longer cartridges are a pain to get free from the cylinder for a speed reload, and the cartridge is expensive if you don't handload.
Snake Shot in 45 - no better than snake shot in any of my 44's
I have not chronographed any of these loads from the Governor...that is probably something to look into if you want one.
All rounds shot in this revolver were soft shooting.
In a field scenario, the 410 out of a short barrel is all but useless, except for snakes close up. The other rounds are more useful, assuming they get close to a standard 4" barrel velocity (doubtful).
If you want something like this, just get a dedicated 44 Special or 44 Magnum. It can do everything the Governor/Judge can do and more, better. Just make sure you Handload to keep your costs down.
I like what others here have said... it can do a lot of things, poorly.