The 40 is a good cartridge from an auto and should be fine from a revolver provided that its grip distributes recoil well and its barrel/cylinder gap is not excessive.
I initially welcomed the .40 Charter snub, then learned of its inability to accommodate quick reloading via common methods- speed loaders or moon clips. That was my 'wothehell' moment and I lost all interest.
Rimless cartridges create their own set of problems when used in revolvers. When the benefits outweigh the problems, you go with it. The 45 ACP/AR is a prime example of a win in that equation. The 40 S&W? Not so much. I kinda doubt we'll see a rimmed version as we have been down that road