Sorry to hear of your bad luck with the 940 - mine was very different.
I got mine when they first came out. I suppose they were having teething problems with them, and I just assumed since they did away with them, they never got it worked out. Liked the idea, just never trusted them after the second gun.
My second gun was the replacement for the first. Unfortunately, it had the exact same issues as the first (parts in the trigger group broke, tying the gun up to the point it had to be disassembled to get the live ammo out). I always assumed that since parts were breaking, it was that the 9mm was just to hot for the gun. Interestingly enough, my second gun had the same serial number as the first, but it was obvious it wasnt the same gun, as the markings were very different. When that one quit, I told them I didnt want it back in 9mm, and they sent me a 642.
I like the idea of a 9mm revolver, simply for the ease of ammo simplicity. I do load .38, but only because I need to for my .38 revolvers. Since I load a lot more 9mm, it would just make it simple if I could practice with a 940 instead of my 642's.
The moon clips are sort of a good thing/bad thing kind of deal. They are fast to load and unload, but they are somewhat bulky (still better than speed loaders though) and you cant get by with speed strips like you can with the .38's. Then again, you actually could with the 547, so the hunt for the 547 is still on.