Well, if you want a hammer fired pistol, considering that S&W has discontinued commercial sales of their excellent 3913TSW/4013TSW/4040PD models, you might consider trying to find a Sig Sauer P239 to rent. They''re a bit thick in the grip for a single column compact, but they might suit your stated preferences to your satisfaction.
They're produced in both TDA (traditional double action, or DA/SA) and DAK (what they call their enhanced double action in the armorer class).
You might also consider trying to find a Walther P99 compact in their AS (Anti-Stress) configuration to try, though. It offers something akin to a DA/SA action and the triggers become pretty smooth and nice as they're used. Granted, they have plastic trigger assemblies.
I have a SW999c (9mm compact) licensed version in the standard AS-type design and it's trigger has become noticeably better than my favored 3913 over the years. I've also fired over 10,000 rounds through it, though ... (with some periodic spring replacements)
Very nice.
I tend to favor the 99 series when chambered in 9mm, though. I've used the .40 S&W compacts and I find them to have a bit more muzzle snap and whip than I prefer in my "working" .40's. My M&P 40c and 4013TSW are much better in this respect. Even my G27 is a bit better when it comes to recoil management and controllability, as I recall.
Look around and try to rent some different models to see what suits your desires and needs.